pivot table - date problem

  • Thread starter cathyong via OfficeKB.com
  • Start date
C

cathyong via OfficeKB.com

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

Eduardo

Hi,
when applying the filter click on the arrow you see, uncheck sellect all and
check only Nov1 and 9
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Doughnut Chart linked with the slicer in the pivot table 0
Wanted to show 12 month Date in Pivot table 2
Adjust Pivot Table Filter based on a Range 0
Selecting Date Range in a Pivot using VBA 0
Consolidate, Lookup and Sum from dates to months 3
Sum based on ranges pivot table? 2
Chart For Hiring Plan 0
Find the position of a date 6

Top