What's the best method of filtering customers who ...
# suiteanalytics
j
What's the best method of filtering customers who have a certain range of price levels. Simply using "None Of" is not sufficient, as it still pulls in the customer if they have ANY pricing level assigned to them. I tried a few formulas, but nothing has worked so far.
k
Use a case statement to return a 1 when they have that price level - then sum/max/min results looking for a 1 or 0 depending on if you want them included or excluded.
j
Would this be on the criteria or results?
k
Criteria - but do it in results until you can identify that it's working correctly.
j
Finally got it to work. Thanks for the help!