In a relational report, I have a report as follows:
Grp Item Sls$ Str Count Avg$/Store
1 A 10 2 5
1 B 15 2 7.5
1 C 10 1 10
1 - Summary 25 22.5
Grp Item Sls$ Str Count Avg$/Store
2 D 10 1 10
2 E 15 1 15
2 F 10 1 10
2 - Summary 25 25
Summary 47.5
Avg/Store is calculated aggregation with a total rollup aggregation.
I am strggling with getting the % that Grp1 is of the Total or its variance to Grp2 (in effect 22.5/47.5 or 22.5 - 25)
Any thoughts would be greatly appreciated.
Thanks in advance,
Adam.