Percentage function for a group based on another group.
- by Jeff O
I have two grouping levels in a report. Group A can have a Percentage() of the entire report and so can Group B, but I would like to know the Percentage() of Group A of Group B. Even if I code it, it seems like once the inner and outer groups have created their footers, I can't go back to to the inner group and set it's value.
Example:
Group A Total 50
Group A percentage of Report Total = 33%
Group A Percentage of Group B Total = 33% but I want 50%
Group B Total 100
Group B Percentage of Report Total = 66%
Report Total 150