How to structure data model/template to print report totals after each sub-group?
Good Morning All and Hope All Safe and Healthy!
First off,not fun being tagged as your Company BIP guru when one is not even close to that role! :-(
I have a report requirement not total sure proper (best practice) way to structure data model/template or just need to add more global values.
Say I have a report with 5 levels with level 1 being lowest. On each page I need to print all detail (level 1), level 2 (sum of level1) then level 4 and 5 totals. Page break will happen with each level 2 then process repeated for each level 2.
Any insights would be appreciated.