|Summarising Group totals in separate table [message #1793449]
||Wed, 08 August 2018 13:52
| Steve Brown
Registered: March 2013
Long time since I have needed to post on here I hope you can help me!
I have a report which has 2 groups, one - ProductGroup - is "inside" the other one - ABCClass.
This is the layout and example of my report:
Group: ABCClass: A
Group: ProductGroup 1
Group: ProductGroup 1 total: 131
Group: ProductGroup 2
Group: ProductGroup 2 total: 80
Group: ABCClass: A total: 211
Group: ABCClass: B
Group: ProductGroup 3
Group: ProductGroup 3 total: 70
Group: ProductGroup 4
Group: ProductGroup 4 total: 21
Group: ABCClass: B total: 91
This repeats for as many ProductGroups and ABCClass records that are found.
At the very end of the report, I have this table/grid:
ABCClass: A 211
ABCClass: B 91
ABCClass: C 0
There are always a set number of ABCClass heading here. I need the totals for each specific ABCClass group next to it's title, and where an ABCClass is not in the report, I need a zero instead.
How do I achieve this?
Thanks in advance
Powered by FUDForum
. Page generated in 0.01860 seconds