How to set the % running total of pivot table as % of the grand column total, instead of % of each subtotal?

[wendazhe]

I think Excel only allows running total percentage calculation using the subtotal as a denominator. Can I set the grand column total as 100% instead? Thank you!

 

[Sinon]

The percentage calculation is based on whatever you choose. When you add the field in the pivot, go to Value Field Settings -> Show Values As -> "% of Grand Total"