Forum Discussion
Solved
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...
Simple answer, create three measures - one for actual, one for plan, one for variance
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
Here goes what I'm getting:
Customer Actual variance Plan Variance
Abc Inc 7 3 10 3
..But this what I need
Customer Actual Plan Variance
Abc Inc 7 10 3
Simple answer, create three measures - one for actual, one for plan, one for variance