Forum Discussion
Filter a Filter in Pivot Table
I have a data model that is a transaction list, column A is Account, Column B is Region other columns to be reported.
I want to Filter by region, then account. The standard pivot table does not filter the list of accounts that have that region.
Is there a way to do this?
Or you may add slicers with each of these fields.
In drop-down list on top of filter select first Region, filter it. After that select Account and apply filter to it.
I am afraid this does not answer the issue.
Simple example
Acct Region Values
FRED NORTH 100
JOE NORTH 200
SAM SOUTH 150
If I select NORTH as the REGION filter I only want to see FRED and JOE in the Account Filter. Right now I would see Fred Joe and Sam even though Sam is South
