How to add total column on pivot table ?

[paulyeo11]

Hi All

I have a pivot table , which compute Exp type by month.

with michael help , i manage to display the Total Row at the top. So now i can view the month total exp amount.

Now i need to display Column total. can some one help me. So that i can display which is overall total amount on exp type for last 2 year.

Paul

[gaurav2017]

Dear,

Indent Mode (Pivot Table):

If this check box is marked, the pivot table's left (column) dimensions will be displayed in indent mode.

This means that the dimension values will replace the "Total" label, allowing for a compact display with just small indents between dimensions.

Hope this helps,

Regards,

[paulyeo11]

Hi Sir

Thank you for your explanation .

Paul Yeo

TDS Technology (S) P/L

www.tdstech.com

HP +6593261804