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
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
Thank Austin .. Much appreciated your help
Hi I have a similar problem
I am getting
Qtr1 | Qtr2
Product | total sales | variance | total sales | variance
I need
Qtr1 | Qtr2 |
Product | total sales | total sales | variance
can you help ?
