Add Percent Change to pivot table

[NoHandJohn]

I would like to add a column to show the percentage change from 2017 to 2018. I would like to keep the current 2017 and 2018 data as is, and just add one column to the right if possible. When I just add it beside the pivot table the percentages dont follow when I expand/collapse the row data.

[TABLE="width: 251"]
<tbody>[TR]
[TD]Sum of Net[/TD]
[TD]Column Labels[/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Row Labels[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"]2018[/TD]
[/TR]
[TR]
[TD]Sm/Med[/TD]
[TD="align: right"]9596[/TD]
[TD="align: right"]9450[/TD]
[/TR]
[TR]
[TD]L/XL[/TD]
[TD="align: right"]6999[/TD]
[TD="align: right"]5190[/TD]
[/TR]
[TR]
[TD]Proposal Other[/TD]
[TD="align: right"]-10[/TD]
[TD="align: right"]-1[/TD]
[/TR]
[TR]
[TD] Rebated[/TD]
[TD="align: right"]6601[/TD]
[TD="align: right"]6822[/TD]
[/TR]
[TR]
[TD]direct[/TD]
[TD="align: right"]958[/TD]
[TD="align: right"]651[/TD]
[/TR]
[TR]
[TD]project rebate[/TD]
[TD="align: right"]2489[/TD]
[TD="align: right"]2561[/TD]
[/TR]
[TR]
[TD]stock[/TD]
[TD="align: right"]5114[/TD]
[TD="align: right"]5406[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD="align: right"]31747[/TD]
[TD="align: right"]30079[/TD]
[/TR]
</tbody>[/TABLE]

 

[heniek00]

Add a Calculated Field to your pivot. Use the following formula: =('2018'-'2017')/'2018'

 

[NoHandJohn]

thanks Heniek00,

I clicked Calculated Field, named it, and typed in the formula above. I get a "There is a problem with this formula" message box.






.

 

[heniek00]

Ideally change column headers to text e.g. Y2017 or so and remove apostrophes from the formula I gave you.

 

[NoHandJohn]

My years are broken out from "Years of Period". So when I go to try and change, I dont get the option to change 2017 to y2017, I can only change "Years of Period".

I have tried to show as % difference of 2017, and I would just hide the unneeded column but the values never come out correct.

 

[heniek00]

So the table you posted in your first post looks different in your spreadsheet?
Anyway - whatever column names are in your pivot you have to use them in the formula.

 

[NoHandJohn]

No Sir, the table is identical. The years are pulled from one column labeled "Years of Period" the pivot table breaks it apart by date code. Which is were my problem of trying to build a formula comes in. I never get the option to pick 2017 or 2018 to put in the formula.

Thank you for the help. I know the issue is my lack of knowledge on this, and i am in no way trying to sound curt or sassy in my response.

 

[trprof]

Did you solve your pivot table problem? If not, can you post a small sample of your spreadsheet, showing origin and pivot tables?