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

kcville — Sat, 16 Nov 2024 02:26:55 GMT

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 🙂

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

jyothish8807 — Thu, 14 May 2020 04:16:38 GMT

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,

topic Re: Create a measure in pivot table that compares the field value of two dimensions in App Development

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

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