About pivot tables
 

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.

Right-click the Date field button
Choose Group and Show Detail Group
In the End Data box, type your end data, e.g. 3/31/03
In the 'By' list, select one or more grouping options, e.g. Days
Click OK
Click the dropdown arrow in the Date field
Remove the check mark from the 3/31/03 item
Click OK

bay wrote:
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.

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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