Summary Level Total in Pivot Table

[mhmmd_srf]

Hi All,

I have a pivot table. Looks like below:

I want to have a summary level total for each Wholesalers. Like we can do this easily in Straight Table.

How to implement this.

Please help.

Thanks,

Sarif

[stabben23 · Accepted solution]

Hi,

mark year in Dimensions and Expressions and tick "show partial sums" in presentation tab.

[rahulpawarb]

Hello MS,

I agree with stabben23‌ !

Please refer the sample application attached herewith.

Hope this will be helpful.

Regards!

Rahul