% of chnage from prior period to current period

kumar1803

Board Regular
Joined
Jan 7, 2015
Messages
110
Hello I have pivot table where I am showing prior period number and current period numbers.

I would like to add a column in pivot table that auto calculate the % change from prior period to current period.

Please help me how can I add the field to show % of change.
 

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.
The easiest way I can think of to do this is to add a Calculated Field to the PivotTable
In XL2010...
You would do this by clicking anywhere in the PivotTable. Under the PivotTable Tools>Options ribbon, in the Calculation section, select the Fields, Items, & Sets link
In the subsequent drop-down click Calculated Field...

Set the Name of the Field to whatever you want it to be called (e.g. % of Change)
In the formula field, it should be ='Current Period'/'Prior Period' -1
Where Current Period and Prior Period are the associated field names from your Pivot.
Finally, set the field number format to Percentage and you should be good.
 
Upvote 0
Is there a way to remove/delete calculated column? I have by mistake inserted a calculated column without any calculation.
 
Upvote 0
Sure. Go back to Insert Calculated Field (like you are adding one)
Then select the Name of the 'bad' field from the drop-down and click the Delete button.
 
Upvote 0
Is that really necessary? A Value Field Setting opotion is Show Values As... % Difference From and choose (previous)
 
Upvote 0

Forum statistics

Threads
1,222,029
Messages
6,163,487
Members
451,838
Latest member
DonSlayer

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top