locked
How to calculate one PowerPivot column as % of another column? RRS feed

  • Question

  • In Excel, this is simple, but how do I do it in a PowerPivot pivot table?

    Column A = Share of purchases (show value as > % of column total) – e.g. 3%

    Column B = Share of store shelf – 1%

    Column C = Index of purchases as % of Share of store shelf – e.g. 3 (3/1)

    Thank you in advance!

    Monday, December 5, 2011 10:14 PM

Answers