Calulate Delta from a dimension

[livio218526]

Hi Everyone,

I have a file with different value. I'd like to have a delta from a dimension depending on another dimension (Scenario).

For example:

Scenario          Output

ACT2017         20

FORE2017      40

ACT2017         90

FORE2017      10

I want in ouptu this:     ACT2017-FORE2017 ---> 60

Thanks,

Livio

[sunny_talwar]

May be this

Sum({<Scenario = {'ACT2017'}>}Output) - Sum({<Scenario = {'FORE2017'}>}Output)

[livio218526]

No, in this way i'm able to see the result only in the Totals, but I want a field only with the delta's value so i can use it for chart.

Thanks