how to do percentage change on pivoted data

[hannah_r]

I was trying percentage change measure where I have the date column and the total revenue I pivoted by product field wanted to study percentage change in revenue of each product in such a way. But found that due to pivoting the percentage change measure is not giving the right results kindly help it resolve.

Thank you

[antho]

Hello,

I think you can accomplish it with Quick Calculation like this:

Which will give you this: for each of your pivot, % evolution for each date :

Antho

[hannah_r]

Hi Antho thank you for responding 
I actually want this specifically to be a measure so that I can drill down to a granular level.
Table calculations were not helping that is why I wanted to do it as a measure.