View Single Post
  #1   Report Post  
Old December 9th 04, 09:33 PM
martin
 
Posts: n/a
Default Pivot table help:calculated field based on previous consecutive va

Hi,

I have a simple pivot table with products in rows and quaterly sales in
columns. I would like to see sales as quaterly change in sales based on
previous year quarter not the previous quarter.

I cannot seem to be able to figure how to do this but since this is so
obvious feature I must be overlooking something. Any help appreciated.

Thanks.