Not in Top n filter

Hi
I am trying to create a report a report where I filter for a dimension not to be in top n by some measure.

The reason for this is that we want to track sales by our top categories in one report and then the rest in another report.

The logic should be fairly easy for you to add as the only change is that the where clause should be “not in” instead of “in” the list of the top n values.

In terms of the UI, I would just add another option called “Not Top N”