so basically you want a YTD,LYS and MTD total at the Industry group level and the value in your dataset are per row so it repeats for each detail row, correct?
You can use Running Totals or shared variables to get the values. Both need to be placed in group footers (if placed in a header it will not show the correct values).
I prefer Running totals so here is an example of that:
Right click on RT fields in the field explorer and select new
Name=YTD_Industry
field to summarize=YTD
Type=Sum
Evaluate= on chneg of group (select group 3-customer)
reset= on change of group (group2-inustry)
OK
drag and drop onto GF2
IP Logged
