| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Table filtering dates
XP w/ Excel 07
I've got a year's worth of orders. I need to create a PT that shows only the orders placed in January. When I try to filter the dates it gives me an option to click on individual dates, but I can't seem to enter a range of dates. Anyone got any suggestions?? Thanks. Ken. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Pivot Table filtering dates
On Apr 13, 12:32 pm, KJ wrote:
XP w/ Excel 07 I've got a year's worth of orders. I need to create a PT that shows only the orders placed in January. When I try to filter the dates it gives me an option to click on individual dates, but I can't seem to enter a range of dates. Anyone got any suggestions?? Thanks. Ken. I would just set up the ranges in an additional column in the data sheet, if possible. jason |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| URGENT PLEASE! Filtering a Pivot Table further | Excel Worksheet Functions | |||
| Pivot table filtering | Excel Discussion (Misc queries) | |||
| filtering pivot table! | Excel Worksheet Functions | |||
| Filtering Pivot Table Data | Excel Discussion (Misc queries) | |||
| Pivot Table "Filtering" | Charts and Charting in Excel | |||
Linear Mode
