I'm trying to filter a pivot table on both rows and values. But everytime I try and do this only one will stick.
Here's an example:
Rows - US States
Values - # of National Parks
Row Filter = AL,AK,AR,CA,CO,FL,GA,HI,ID,IL,IN,IA,KS,TX,UT,VT,WA,WV,WI,WY
Values Filter > 1
When I add the row filter only the 20 states return. Then I add the value filter but there are other states brought back since they too have more than 1 National Park which implies to me that the row filter is no longer used.
Any ideas on how to make both of these filters work at the same time?
Bookmarks