compare values of group within a group

[pko123]

Hi,
I have one report contains 2 groups

Group I contains region
Group II contains subregion

under Group II there is detail for That group.

now for each Region there is Only one DEFAULT Subregion that is defined by Field, IS_DEFAULT = 'TRUE'
Now i Wanted to show the count of records for Default Subregion in the REGION header.

for example

Northwest (group I)        Value = 3
 NY      (group II)
     1
     2
NJ  Default
     1
     2
     3

as you see in above example NJ is default subregion so i want to show count in the Region Header

The problem i am facing is , I have created the formula to count the number of rows for default Subregion and i have put on the Region Group header, its not giving me right result.

Please let me know , if you have any suggestion

 

[lbass]

If you don't have duplicate data within the subregion, you could create a formula like this:

//{@defaultl}:
if {is_default} = true then 1

Then right click on this formula in the detail section and insert a summary(SUM, not count) at the region group level, and then drag it into the group header.

-LB