Pivot table % and $ of GRAND TOTAL only

[KG Old Wolf]

All,

I create a pivot in VBA. It spreads charges by vendor / month. THe grand Total is fine but I also want a column that presents the % of Grand Total for each vendor.

When I add a second charge field in the values section, it correctly calculates the % of Grand Total but it also does the same thing for each month.

I can't seem to create a "calculate" field for just the % on Grand Total.

Is it possible or do I have to "copy and paste" as values to another work area on the sheet and obtain each vendor's % of Grand Total that way?
_____________________________________________________
This is what I am looking for:
Ex. 1/2011 2/2011 3/2011 GT GT %
Vendor A 10 20 30 60 15%
Vendor B 30 40 50 120 31%
Vendor C 60 70 80 210 54%
_____________________________________________________
100 130 160 390 100%

It seems simple and I think I'm missing the obvious! All suggestions are appreciated

 

[MarqyMarq]

Did you ever find your answer? I am also curious as to how to add another calculated column to the the right of the Grand Total column.

Like you, I have tried adding a calculated field using the PivotTable Analysis tab in Excel 2016, but to no avail. It also adds the calculated field to the right as well, which does not causes more work on my side to "hide" the extra columns. Only looking to make a calculation to the Grand Total column.

As a last resort, I can copy my data to another sheet and do the calculations there, but that's seems "backwards".

Yes, it seems simple.