Pivot Table Partial Sums Help

[#1]

Hi,

I have a pivot table with dimensions Agency, Client, Parent, Network, Buy Type and Year. I have expressions for Total Spent and Year over Year. After each client, I want to show a row that has total spent for that client and year over year change. I tried to implement this by checking 'Show Partial Sums' in the Presentation tab of the table, but that shows one row at the end for all the clients whereas I want a row after each client.

Any help? I've the portion of my application with fields scrambled to help illustrate my dilemma. Let me know if you need further elaboration.

Thanks and best,

Ryan

[swuehl · Accepted solution]

I think you need to enable the partial sum on presentation tab for parent level (summing all parents grouped by Client).

[#3]

yes, thank you.