Create Customized and Conditional subtotals

[chandakaushik]

Hello guys,

I am trying to create a conditional subtotal in a PowerPivot. Can someone please help?

Subtotal = Rolling Difference GRR + Compass + CaptiveManual + DuePremium Life

GRR shouldn't be added in the subtotals.

[stevedep · Accepted solution]

Perhaps this is what you are looking for?

___SumPolicy = IF(ISFILTERED('Table'[System]), SUM('Table'[Amount]), CALCULATE(SUM('Table'[Amount]), 'Table'[System] <> "AD"))

As seen here:

As demonstrated here. 

Link to file here. 

pls mark as solution if so.

Kind regards,

Steve. 

[chandakaushik]

@stevedep Thank youso much! You're awesome! 🙂 

[stevedep]

@chandakaushik , Does this work for you?