Hi there,
I am trying to create a filter which will allow me to predefine some combinations of the filter items but exclude others.
My Data looks similar to:
OrderIDType1Toys1Games1Appliance2Appliance3Games4Toys
What I'd like to do is have a filter that would group "Toys and Games" together, so that when I filter for "Toys and Games" only Order 1 Comes up.
Thus excluding all orders that don't meet this combination criteria. I've been able to filter on Toys, or Games and it brings back 1,3 or 1,4
If I have both types selected it brings back 1, 3, 4
So it looks like the normal quick filter action is using an "OR" statement. Is there a way to create an "AND" statement?
I would have a filter for each individual type as well, but to have combinations of Types which would exclude the single values of the combination?
I have been trying to get my head around Sets but I seem to be hitting a wall.
Any help would be appreciated.
OK and you should also look at the new in V8 'Combined Fields'.