Variance - Actual vs Plan in Matrix

[Gjorge]

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 

[austinsense]

Are you putting the scenario column on the report as well?

[Gjorge]

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

[austinsense]

Cool, you have two values for each scenario, two scenarios * two values = four columns

[Gjorge]

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

[austinsense · Accepted solution]

Simple answer, create three measures - one for actual, one for plan, one for variance

[kohlivinayak]

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 ?

[Gjorge]

Thank Austin .. Much appreciated your help