Get column count percentage base on the ranges

[xiaoxuep]

Hello,

I need to create a statistics summary report. Can someone help on what I can do to setup the group as a range of values, also calculate the percentage of the group count and group balance totals?

Here is the requirements:

I have a main report with the account number, balance...

Then in summary report, I need to have:

         Balance Summary (field ln.bal in 100000 increment ranges)

From    To              Count                     %                  Total                     %

0 - 99999                      5                    0.45%      23185.45           2.34% 

100000 - 199999       76                  5.45%      4567334.56      10.34%

 

Thanks a lot.