Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table - date problem
hi
Though I have been using Excel for quite a while. I just did my first pivot table today. I need a report based on specific date (Actually it is every Sunday). The date I have entered are Nov 1, 2009 and Nov 8, 2009) in the Excel but when I used date as the page report filter. The date filter is <Nov 1 Nov 9 with many dates in between. How do I make it to show only Nov 1, 2009 and Nov 8, 2009. I really very happy because pivot table really useful tool except for my problem re date. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200912/1 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
pivot table - date problem
Hi,
when applying the filter click on the arrow you see, uncheck sellect all and check only Nov1 and 9 "cathyong via OfficeKB.com" wrote: hi Though I have been using Excel for quite a while. I just did my first pivot table today. I need a report based on specific date (Actually it is every Sunday). The date I have entered are Nov 1, 2009 and Nov 8, 2009) in the Excel but when I used date as the page report filter. The date filter is <Nov 1 Nov 9 with many dates in between. How do I make it to show only Nov 1, 2009 and Nov 8, 2009. I really very happy because pivot table really useful tool except for my problem re date. -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...mming/200912/1 . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Problem inserting calculated pivot fields into Pivot Table (2007) | Excel Discussion (Misc queries) | |||
Problem Converting date to month in text for use in pivot table | Excel Worksheet Functions | |||
Pivot Table in Excel 2007 : Problem with % in Table | Excel Discussion (Misc queries) | |||
Pivot Table sorts date as Alpha, not as Date | Excel Worksheet Functions | |||
Pivot Table Problem | Excel Worksheet Functions |