How to add Sub Total and Grand Total at Pivot Table?

[#1]

Dear Experts,

          I would like to get Sub Total & Grand Total at the Pivot Table. But I have some other aggregation functions on that pivot table. What is the appropriate way to get the answer at that situation. Please see the below table.Hope to help me.

Best Regards,

Kyaw Myo Tun

[awhitfield · Accepted solution]

Hi kyaw,

have you tried 'SHOW PARTIAL SUMS' on the presentation tab? Set it for the required dimensions

Andy

[#3]

Dear Andy,

         It works correctly. Thanks for your precious help.

Best Regards,

Kyaw Myo Tun