Top N Condition with a character filter.
I created a "Top 20 Customer" condition based on Sales. The query runs fine and reports the Top 20 Customers on a "Global Customer" chanacteristic..
I would like to filter a particular "global customer from my results. What we do is assign a generic global customer number to a select few 0SOLD_TO customers. They roll up to our generic global custromer #. We would like the ability to filter this value out and have the 21st value represented. Is there a way to filter on the condition. I can not filter on the query due to the requirement to reflect all sales on a defined period.
Any thoughts how I force the condition to give me results based on this restriction ?