Comparing values and showing %

[Piotr]

I have a pivot table

2004
values
....
...
2005
values ascending which I refresh monthly


I vish to have at the bottom table showing % 2005/2004, but it is
quite difficult as pivot fields in 2005 keep on changing every month,
can I create a pivot table to show % between two years ?

 

[Dave Peterson]

You may want to look at Debra Dalgleish's site:
http://www.contextures.com/xlPivot10.html

She has lots of custom calculation instructions on that page.