I have a stacked area chart showing number of products bought per type. Now I want to break this out by promocode. The issue is we have 100s of promocodes and most of them have barely any data. How would I filter it down so I only show promo codes that have a significant number of sales (say 100 or more) for the time period? I don't want to filter out data points, I want to filter out the promocode completely if it doesn't have a total of a 100 or more sales for the period. This is just an example, but I often find myself looking to do this and I'm not sure how to go about it.
So here any row (promocode) with less than 100 sales would be filtered out completely.
A big bonus would be to be able to sort this by total sales in the time period, so the rows with the most data show up on top