All,

I am filtering a Pivot Table with it's associated group and data. When I want to filter the group that is greater than 84 (I have about 90 groups), I go to Row Labels drop down - Label Filters - Greater than and input 84. When my filter is done, the number 9 appears. Why is this?

Hi Eric,

According to your description, this issue is related to pivot table of excel, the Excel IT Pro Discussions forum is a better place for this issue, we will move it there for you.

Regards

Starain

Hi Eric,

Based on your description, I created a PivotTable in my own environment with any simple data. I filtered the data but I cant reproduce your issue, maybe my sample data is incorrect.

I suggest you upload a screenshot so that I can get more accurate solutions to your issue.

If you have no verified to post the screenshot, please share the screenshot or a sample file via OneDrive.

You can also send the screenshot or the sample file to our email address:

ibsofc@microsoft.com I'd like to help you check it.

Please Note: The email subject you should use the URL or the Title Name of your case.

Im glad to help and follow up your reply.

Regards,

Melon Chen
TechNet Community Su