Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 🙂
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