Pivot Table Value and Label Filters

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
Reply is a bit late, i know, but i was just trying to find this out myself.

Found this in the help file on pivottables:
You cannot filter by label, date or time, value, or top or bottom numbers if the PivotTable data source is an OLAP database that does not support the MDX expression subselect syntax.
Click to expand...

Googling found the microsoft blog on this and i fixed it on my workbook (Excel 2007, windows XP pro) by saving as a xlsx or macro enabled workbook, instead of xls (97-03 is my default)
 
Back
Top