Group within Top N

[princessinthetower]

I have a report that uses top N to order individuals by total amounts. Is there a further way of grouping these individuals by ranges like this

$1,000 - $2,499
$2,500 - $4,999
$5,000 - $9,999

in order to count the number of individuals that fall within each range? The $ amounts are already a summary and can't be counted.

 

[Ksquared]

What i'd do is make a new field, using a formula, test the value of the $ field and give it a new value. (eg if $1,000 - $2,499 then 1 or if $2,500 - $4,999
then 2 and so on. Then you can group by and count this field ....

 

[princessinthetower]

Unfortunately, as I said, the dollar amounts for each person are a sum of amounts not a single amount. If put into a formula, the formula cannot be used to group or count.

 

[princessinthetower]

I found a solution. Although I cannot group on the range formula because it contains a summary, I can create a running total for each range to count the number of individuals and put them at the end of the report. The evaluate section can be based on a formula and it accepts formulas that contain sums. It's tedious, but it works.