Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
georgio_hb
Contributor III
Contributor III

How to Calculate YoY (Year Over Year) Growth in Pivot (Having multiple Columns)

I tried the before function by using this measure: (Sum([Sales Volume])/Before(Sum([Sales Volume)) - 1) but it gave me wrong numbers.

I need to get the growth between JF 2018 and JF 2019 , MA2018 and MA2019 and so on..

As highlighted in the image. (The pivot is filtered, there are more years 2015-2019)

Labels (4)
1 Reply
katherine_cooney
Contributor
Contributor

@georgio_hb,

Were you able to find a solution to this problem? I am running into a similar problem with my data now and I was wondering if you had found something that was helpful.

Thanks,

Katherine