ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot Tables - Date Filters (https://www.excelbanter.com/excel-discussion-misc-queries/205405-pivot-tables-date-filters.html)

Craig

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


All times are GMT +1. The time now is 12:42 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com