How to make selections mean 'OR' instead of 'AND' set conditions
Is there a way to have a listbox that will be used as selection criteria be used as an 'OR' selection and not an 'AND' selection?
For example, normally when I do a selection in the listbox and select 3 choices what I am left with in my corresponding chart is the data which meets all 3 selections. So if the listbox contains a list is of skus and I select 3 skus, and the chart is purchases by customers of those skus, I will only see purchases for customers who have bought all 3 skus. I would like to see purchases for customers who have bought ANY of the 3 skus, not only those buying ALL 3 skus.
It seems like I should be able to do this somehow but I can't find anything. Please help!
Ok, it probably is my chart expression then. I am trying to show only invoice quantity * selling price but only if the order was made within 90 days or 120 days after an event. It all works perfectly with only one event selected but as soon as I add a second one to the current selections the 2 columns go to 0. The same customers and orders may show in event 1 and event 2 as I am comparing orders bought by customers after the event.
