How to Create a % Change ROW in a Pivot table

[jcampbell474]

I need to create a row that displays the 2016 vs. 2017, % Change, by month.  I can calculate the % Change and put it in a column all day long, but do not know how to make it a row (for each Metric). 

Here is a sample of what I need.  I have the pivot table created, just need the % Change row in bold.  What would be the best way to go about this?

Thanks in advance,

Jason

[Anil_Babu_Samineni]

He created sample Re: Percentage Subtotal

[jcampbell474]

Thank you.  That's very helpful, but doesn't fit my requirements.  I need to get the % change per dimension value, not of all values (Grand Totals) and percent of total.

Thank you for the reference though, I can see it coming in handy at some point down the road.

- Jason

[Anil_Babu_Samineni]

May be share qvw file so then we can work for you

[jcampbell474]

Okay, here is a sample.  Thank you for the help!

[sunny_talwar · Accepted solution]

Check attached

[jcampbell474]

My goodness, Sunny.  That was fast.  It looks to be exactly what I need!  Going to spend some time figuring out what it does and implement it into the application.  Will let you know if I run into anything.

Thank you!

[sunny_talwar]

There is this other option... but then the % change is highlighted in gray