Forum Discussion
Variance - Actual vs Plan in Matrix
When I add a new measure (in to the value field) that provides the difference between actual and plan, I'm getting two additon al column
This is how i'm calculting variance
Variance = CALCULATE(sum(PB01[Sales]),PB01[Scenario]="Actual")- CALCULATE(sum(PB01[Sales]),PB01[Scenario]="Plan")
This is what i'm getting
Customer Actual variance Plan Variance
Abc Inc 7 3 10 3
The dataset has the following colums
Customer
Sale_Amount
Scenario : Actual, Plan
Simple answer, create three measures - one for actual, one for plan, one for variance
7 Replies
Are you putting the scenario column on the report as well?
Yes. This is the setting for the matrix;
Row : Customers
Column: Scenario
Value: Sales
I tried to add new calculated field ( variance) to the Value and got two additional columns
Cool, you have two values for each scenario, two scenarios * two values = four columns
