Pivot Table Page Field
 

Hi There,

I have a simple pivot table that shows sales by salesperson, per month.
Months are represented by accounting period numbers (i.e. apr =1, may=2,
.....march =12)
The period numbers are the page field, so i select a period from the page
field and it shows me the sales for that month by salesperson.
However, I have the period in cell A1 that changes in real-time, can I link
the page field to this cell, so instead of me having to increment the period.
It simply picks it up from A1.

Any help is appreciated

Jim