View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Jenzz22 Jenzz22 is offline
external usenet poster
 
Posts: 4
Default Pivot table show only current month?

I have a pivot table with the date (8/1/2009 - dates always are the first of
the month) currently in columns. I would like to only see the current month.
I have worked with other pivot tables that I did not create where the month
is in the page field and it pulls only the current month but I can not figure
out how to do it or if there is another way?
Thank you
Jenifer