Hi
In the attached workbook, I'm having a problem with setting up multiple filters for products ordered with a combination of options.
Sample data set has 4 columns;
I would like to preferably set up quick filters (but I'm open to any other solution) which allows me to find the quantity of products with "Option" X AND Y AND [Z OR Q]. So the filter would output the quantity of product appearing in "Order Main line' which was ordered with three options in total (X,Y and one of either Z or Q).
Help would very much appreciated!
Hi Mikolaj,
Do you mean by
X AND Y AND [Z OR Q]
that the condition to be applied to each [Order number] aka Basket?
If yes, then please find the attached. If no, please explain your logic to the dummy :-)
Yours,
Yuri