Value filter in the pivot table is disables

V

Venice

Hi I created a pivot table containing all the numbers. The filter can only
display the top 10 features, while the rest are filter are grayed off.
So I went to the Pivot Table Options and found that Pivot Table Options >
Total & Filters tab also gray off the "Allow multiple filters per field" box.
How can I enable it back? Pls help. Thanks.
 

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

Slicers and Calculated Items in Pivot Table 2
VLOOKUP a Pivot Table Filter 0
remove lines in pivot table with zero values 0
Filtering by group in pivot table 0
date filter in a pivot table 1
Pivot Table Missing Filter Tab 1
Pivot Tables - Date Filters 0
2003 Pivot Table Filter (items dropped in the Page Fields) 1

Top