Pivot table displaying last 12 months

A

Acro

I would like my pivot table to display only the last 12 months of data.
Is there a setting i could change somewhere to make it only give me the
last 12 months?
 
N

Nick Hodge

Right click the date header in the pivot table and select group. In the
dialog type a start and end date. The 'auto' check boxes will automatically
uncheck

When the resulting pivot table is build, remove the < and > dates in the
filter

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
www.nickhodge.co.uk
(e-mail address removed)
 

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

Presenting all months in a year in a Pivot Table/Chart when allmonths are not included in source dat 0
rolling 12 month date filter for pivot table? 2
pivot table rolling 12 month filter? 1
12 month pivot table 16
Removing Pivit Table Items 2
Pivot Chart Data Table 1
How to chart months by financial year 0
Pivot Table: Totals for "Last 12 months" and "Preceding 12 months" 3

Top