Running Totals On Group Headers

[codrutza]

Hello

CR2013

I have running total sales in the Group Footer Year and the running totals for each client. I can't use sum.
I know that I can't have the running totals in Group Header, but I have to display the Total sales per year first.
Is it a way around this? Could I have within the group client the total year somehow? Or something?

[pre]
Total Total Sales 2017
ClientA Total Sales ClientA
ClientB Total Sales ClientB
ClientC Total Sales ClientC
....
Total Total Sales 2016
ClientA Total Sales ClientA
ClientB Total Sales ClientB
ClientC Total Sales ClientC
....
[/pre]

 

[lbass]

You need to explain why you can't use a sum. Are you suppressing records? Are you using group selection? If so, what are the formulas you are using to do this?

-LB