I am not looking to drilldown into the details area and I don't know if this is possible. This is an example of what my report might look like:
Group 1 Count of Records
>$100 (Group2) 20
$100-150 (Group2) 3
$150-200 (Group2) 3
$200-250 (Group2) 380
$250-300 (Group2) 175
$300-350 (Group2) 14
Group 1
>$100 (Group2) 14
$100-150 (Group2) 265
$150-200 (Group2) 48
$200-250 (Group2) 7
$250-300 (Group2) 2
$300-350 (Group2) 1
Group 2 is a formula field:
If {reportfield1} >= 1.0 and
{reportfield1} < 1.5 then "$100-150" else
etc.
Depending on Group 1 the ranges in Group 2 might have hundreds of records or just a couple. When there are just a couple then I would like to combine those groups into a larger range and when there are hundreds of records I would like to break down the range for more detail. Any help would be appreciated.
Edited by johnsjg - 10 Jun 2013 at 9:07am