How to calculate a column percentage based on RRS feed

  • Question

  • I am trying to create profit and loss statement with a % of revenue column in PowerPivot.  Trying to figure out how to get all rows in the resulting pivot to have MTD as a percent of the Revenue Total row.

    (Where Cat1 = “Revenue”)

    I wanted this to calculate depending upon which department I select – so the Revenue Total row will change based on this context.

    See the following picture of what I wanted. 

    % of Revenue  =  [MTD] / (Total of [MTD] where Cat1 = Revenue]

    Wednesday, October 31, 2012 7:59 PM