Hi All
I'm trying to work out how to show difference from previous month in a pivot
but what I'm looking at is the % of the column total change month on month
example:
Supplier Jan Feb Mar
A 5% 4% -1% 2% -2%
B 3%
C 2%
so if we look at supplier A the % under each month is the % of column and in between them is the movement month on month.
Feb has gone down 1% so next to Feb is -1% etc
Any ideas how this can be done?
Hope this make sense
Thanks
Bookmarks