Maybe you could use a helper column.

=if(a2<date(2003,4,1),"Show","Hide")

And drag down.

Then use this column in the page field.

bay wrote:

Hello,

I am working on a pivot table that displays data from various dates from
1999 to 2005 and i would like to filter it to show only the data coresponding
to dates up to march 2003. How do i do that? I cant go do it manually from
the date column because the dates are over much to many and if I try to hide
details for months jan to march , it seems that it hides the data for all
years including 2004 and 2005 which i want calculated in the pivot table.

any help guys?

thank you in advance,

bay.

--

Dave Peterson