I have a pivot table that has a row header (Year) that contains data for 2012 and 2013. I want to add the subtotal row however I need it to display the percent change from 2012. Does anyone know how to accomplish this?
This is a small sample of the data
Year EQ Cases DC EQ Cases Colorado EQ Cases Florida EQ Cases Georgia
2013 2.8 0.9 3.8 1.2
2012 11.8 10.6 2.0 15.1
Could you post your workbook?
If you arehappy with the results, please add to the contributor's
reputation by clicking the reputation icon (star icon).
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved.
To undo, select Thread Tools-> Mark thread as Unsolved.
http://www.excelaris.co.uk
Here is a little section of it.
Thank you.
Is this really your Pivot?
Its a little section of it.
Sorry but this does not look like PT.
I cannot send the entire PT it contains sensitive information.
Perhaps you can add your data field a second time and show it as 'percentage difference from' choosing 2012 as the base item. I can not be sure without the real pivot.
I can do that however that creates another column and I need it where the subtotal is now.
Without your proper layout is hard to say.
copy part of your data, create a PT and post a workbook.
If you do not have custom groups you may use a calculated item using formula =('2013'-'2012')/'2012'
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks