Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot Table
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 HIS "Mike Archer" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
how to create pivot table from existing pivot table in excel 2007 | Excel Discussion (Misc queries) | |||
Print Pivot Table headers on pages with Pivot Table | Excel Worksheet Functions | |||
Filter lines with Pivot table and non pivot table columns | Charts and Charting in Excel | |||
Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
Help required with setting up a pivot table with the source on sheet1 to have the pivot table created on sheet called "report" | Excel Programming |