Forum Discussion
Advanced Filter
The way I worked around this was to create a lookup table by group representative name. Then I was able to sort this particular group as well as three others. I didn't really need to create a master list but it is the same idea.
I stumbled on a workaround for this limitation of two (2) Advanced Filters. First I determined the number of filters I needed to get the results I was looking for. In my case I needed 5 filters. Instead of choosing "Advanced Filtering", I chose "Basic Filtering" and then chose 5 random selections. I then switched the drop-down from "Basic Filtering" to "Advanced Filtering" again, and it presented me with 5 filters vs the default of 2. Be sure not to hit the "Apply" button until you have filled out all 5 of the filters because as soon as you hit apply, any filters that are left blank will dissappear.
Hope this helps....
Is this still working?