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