Hi
I'm trying to calculate the percentage change between values on a pivot table.
I have attached a sample. What I want is for each column to know the %change for each day ie by how much was the new value up/down based on the previous day. I can do this the normal way by calculating %change and get the results but when I come to copy the formula (by dragging it down the rest of the columns) it just repeats the same number as in say E5 for when trying to find the % change of 1129 over 1107.
I can do this manually for every line but that will take a lot of time. Is there any way in a pivot table to still calculate the differences and have this done automatically for all rows (by dragging it down)?
In my real table I have hundreds of rows which will take a long time to find the % change for each one.
Is this possible? If so please tell me how.
Thanks
Bookmarks