Could anyone tell me why the value filter doesn't work in excel pivot tables? The instruction seem pretty straightforward and easy, but when I apply a filter, nothing changes. What am I doing wrong?
The attached is a generic example. There are two pivot tables, one without the filter and one with the filter applied. Any ideas? Value-Filter-Issue.xlsx