Pivot table-percent of column

[Guest]

Can the show data as "% of column" function be set to show as a % of the subtotals instead of the total? For instance, I would like to see the color of cars sold by state as a %, but I want each state to add up to 100% rather than the just the % of the nation that state represents.

 

[Debra Dalgleish]

AFAIK, you can't calculate the percent of a subtotal. You could do the
calculation outside of the PivotTable.

 

[BrianB]

Ref Debra
<AFAIK, you can't calculate the percent of a subtotal. You could do th
calculation outside of the PivotTable.>

I have found this too - even in a calculated field, because it is no
possible to access the Totals cells using this method.

The way I do this is to use VLOOKUP() in the column containing, fo
example, "Business Total". Everso easy. I have struggled wit
GetPivotData lots of times and given up

 

[Debra Dalgleish]

And VLOOKUP is consistent across versions of Excel, while GETPIVOTDATA
isn't.