Any way to do this wit filters? (Ex. Atlanta and GA or Atlanta and Michigan or Atlanta and Nebraska)

[okami]

Hey All,
 
Is there anyway to kind of chain a filter to do something like in the subject?
 
So the situation is more that I'm lookin up a list of employees in a certain location under certain divisions.. But just because they are in a certain location doesn't mean they are in the same divsion. So I need something like
 
Division A And Location A or Division B and Location B
 ETC
 Thanks so much for your help!!!!!

[Anonymous]

Hi @okami，

Could you please share sample data of your tables and post expected result here?

Assume that you have a table as follows,  you can create two slicers using Location field and Division field, then use the slicers to filter your table.

Thanks,
Lydia Zhang