Pivot Table

M

Mike Archer

Hello.

Is there a way to filter a date range in a pivot table?
As far as I can tell, each date must be selected or de-
selected in a date field.

TIA
Mike
 
N

Nick Hodge

Mike

If you want a single date, make it a page field and select the date from the
drop-down.

If you want a range of dates then right click the date header and select
'Group and Outline'. If you get an error Excel doesn't see them as real
dates. Now select a start and end date and it will 'filter' to those only.
(From here you can also make it show as months, quarters, years or even
weeks by setting it to days with a frequency of 7.)

Don't forget if you use months or quarters and your data spans over a few
years to add years as well or it will total all years into the month (May be
desirable, but may not).

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
[email protected]
 
Top