I'm having an issue getting two things to work together, Freeze panes of a pivot table, and the ability to filter by pivot expressions. Here is an example
I'd like to have Alpha at a frozen state that will allow the user to keep viewing it as they scroll horizontally. The problem is when I press a field it will only return that one line item (say I select green i get the results below).
Ideally, I would like both rows that contain green to be returned when I select "green" and have the ability to have a frozen column. I'm aware that a table box will let me filter on selections but it does not have the ability to freeze pane. Is there a work around around this? or some kind of solution?