Why my Value Filters filtered out everything and included nothing?
16:31 15 Mar 2026

I have a pivot table that looks like this. The numbers in this table are the number of grades

enter image description here

I'm trying to remove courses that have more than 80-20 grade distribution (ie a course should not have more than 80% of grades in OER or Not OER. And a course should not have less than 20% of grades in OER or Not OER). Once I obtained the above table, I clicked the down arrow by Row Labels --> Value Filters --> Between (See image below)

enter image description here

I entered the my desired range 0.2 and 0.8

enter image description here

The result I got was "nothing" (see image below)

enter image description here

While the desired result should have been the following

enter image description here

How can I obtain the desired result? Which part of the filter did I not do correctly? Thank you!

excel