Adding additional colums in the pivot table

Please help me in adding additional columns in to the pivot table after the GRAND TOTAL column as shown in the attached spreadsheet.

Not sure which additional columns you require. Please explain further. If these are calculation based on your pivot table results, you could populate them in the adjacent columns

Also, is there an option to remove the grand total column ? I want to keep the grand total column in the spreadhsheet for now. I am just asking for curiosity sake

Yes, right click anywhere on the pivot table--got to pivot table options--uncheck the grand total for rows checkbox

hope this helps!

A few questions..
- Where do you get the value in N26 from?
- Where do you get values in I19:K20 from?

Since these are calculations based on values which are external to your pivit table data, you would have to calculate them outside the pivot table, just as you are doing now

Hi there,

Grand total would always be last column... you can add extra column but then those would be outside the pivot.
Option to remove the grand total column -> Right click -> pivot table options -> Total & filters -> Uncheck options for " Show grand totals for rows and columns "


Regards,
DILIPandey

<click on below 'star' if this helps>

Can you please give me a formlua to calculate the Total Sales for Japan-Tokyo $7441.00.

In your sheet use
=SUMPRODUCT(--(C2:C24=I10),--(D2:D24=I11),E2:E24)