ExcelBanter - Pivot Table Value and Label Filters

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Table Value and Label Filters (https://www.excelbanter.com/excel-discussion-misc-queries/133719-pivot-table-value-label-filters.html)

Larry

Pivot Table Value and Label Filters

On a number of pivot tables I'm using, the "value filters" and "label
filters" options are greyed out. The only thing which is allows are "top 10"
value filters. This is occuring both for pivot tables created out of analysis
services and pivot tables created on the fly. How can I enable these types of
filters?

All times are GMT +1. The time now is 08:29 PM.