Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Blank Cells in Pivot Tables | Excel Discussion (Misc queries) | |||
Macro for Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot Tables | Excel Discussion (Misc queries) | |||
Product Function in Pivot Tables from Multiple Consolidation Range | Excel Worksheet Functions | |||
How does the term 'pivot' apply to Excel's Pivot tables and Pivot. | Excel Discussion (Misc queries) |