How to calculate a column percentage based just one of the summary rows

[cgkitab]

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]

 

[Mavericks334]

Try this link it will help you

Profit & Loss (Part 2)–Compare and Analyse « PowerPivotPro

 

[Laurent C]

Assuming you already defined your MTD measure, you can try something like that:
% of Revenue := [MTD]/CALCULATE([MTD];Data[Cat1]="Revenue", ALL(Data[Cat4]))

Note that Data is the name of my table. If you have intermediate levels between Cat1 and Cat4, you will probably want to have them mentioned in the CALCULATE part.

CALCULATE([MTD];Data[Cat1]="Revenue", ALL(Data[Cat2]),ALL(Data[Cat3]),ALL(Data[Cat4]))

If you have all these categories in a single dimension table, then you will be able to write something like:
CALCULATE([MTD];Categories[Cat1]="Revenue", ALL(Categories))