Pivot table show only current month?

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
 
S

Sean Timmons

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

Creating a Search using a combo box and then creating a report. 4
Dealing with a Pivot Table (when I don't want to) 0
Pivot table 0
Formula to Look up values from a pivot table 1
Doughnut Chart linked with the slicer in the pivot table 0
date calculation in pivot table to show products over agreed date? 0
Pivot Table Counting Text Data 0
pivot table data 2

Top