Forum Discussion
Advanced Filter
- 9 years ago
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....
- lemarcfj7 years ago
Helper I
Wow this worked for me. It is truly so pathetic that you have to hack it this way for just a fundamental functionality.
- nw2caac25 years agoRegular Visitor
Absolutely fantastic 👍 worked a treat, can't thank you enough for this great helpful hint 😊
- scabezas5 years agoFrequent Visitor
Thank you for the tip, worked like a charm
- Anonymous5 years agoNot applicable
Worked like a treat, you've helped so much
- Roger_M5 years ago
Advocate I
Thank you, this worked just fine for me. 6 filters.
- virakones4 years ago
Advocate I
Gotta say this worked very well and is probably the funniest UI workaround ever.
- mangchaaBI3 years ago
Helper II
Is this still working?