Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - Date Filters
What condition will cause the Date Filter to not be available in a Pivot Table?
I have multiple pivot tables using one source (possibly different ranges, but all including dates). One or two pivot tables are able to use the Date Filter on Row Labels and others the Date Filter option is grayed out and only Top Ten under Value Filters is available. The date columns appear to be in the default date format. Thanks -- Craig |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table filters, especially DATE filters | Excel Worksheet Functions | |||
filters in pivot tables | Excel Discussion (Misc queries) | |||
Advanced filters in Pivot tables ? | Excel Discussion (Misc queries) | |||
pivot tables by date range | Excel Discussion (Misc queries) | |||
Using Date Grouping in Pivot Tables | Excel Discussion (Misc queries) |