restrict data in a pivottable

[Guest]

Hi,

how can I resrtict the column and row values in a pivot table.
for example of "date" is my column heading, and the base data has dates from
2004 and 2005, can I force the date "drop down" to only include those dates
from 2005 (so you could never have the option of clicking a 2004 date)
thanks

 

[Ed Ferrero]

Hi confused,

Right-click the date column heading.
Select Group and Show Detail, then Group... from the pop-up menu.
Group by Days and Years, then click OK.
Drag the Years column heading to the Page Field area.
Select a year from the page field drop-down.

More detail is available at my Pivot Table tutorial at
http://edferrero.m6.net/tutorials.html

Ed Ferrero
http://edferrero.m6.net