Pivot table show only current month?

  • Thread starter Thread starter Jenzz22
  • Start date Start date
J

Jenzz22

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
 
Are you saying you want the table to "know" which month is current, or you
want to be able to manually hide other months?

To manually hide others, click on the drop-down arrow in that column header
and uncheck Select all, then select your desired date. Otherwise, you're
looking at using macros to select current month.
 

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

pivot table data 2
Group in Multiple Pivot table 1
Pivot Table Duplicate January 2
Pivot ungrouping on refresh? 3
Pivot Table Variance 2
Pivot table problem 4
pivot table rolling 12 month filter? 1
Aging Report 4

Back
Top