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....
Wow this worked for me. It is truly so pathetic that you have to hack it this way for just a fundamental functionality.