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.
|