Create a measure in pivot table that compares the field value of two dimensions

[kcville]

Hello

I have a pivot table with Department rows and columns of Years. 

I have a measure of Sum of Sales, how do I create a new measure that gives me the % increase from the Sum of Sales 2018 to Sum of Sales 2019.

I tried to use Set Analysis, e.g. if I create a measure like this...

Sum(${<Year={'2018'}>}Sales))

What I want to see from that expression was the Sum of Sales for 2018 in each Dimension/Year (this is just a test as I know I want % increase), but I just get zeros and only results for dimension for 2018.  Ie I want to be able to reference the results from the previous year.

Help would be appreciated as I have spent far too long on this now.

Thank you 🙂

[jyothish8807]

Hi Kcville,

You can simply try this:

((Sum(${<Year={'2019'}>}Sales)) - Sum(${<Year={'2018'}>}Sales))) / Sum(${<Year={'2018'}>}Sales)) ) *100

Note: You can create variable for hard coded years to make it dynamic.

Br,

KC