Pivot Table Value and Label Filters

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?
 
B

bfg67

Joined
May 26, 2011
Messages
3
Reaction score
0
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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

date filter in a pivot table 1
Pivot Table Clear All Filters 8
Single Filter to change all Pivot Tables in a Workbook 8
Grouping Dates in Excel 2007 Pivot Tables 1
pivot table rolling 12 month filter? 1
Pivot table to query data in a set range 3
Copying Sheet with Pivot charts 3
2007 Excel Pivot Tables - turn off subtotals 3

Top