Dynamic Sets (Top N and Grouping Others)

I would like to request enhanced support for dynamic sets in Spotfire.
Specifically, I am looking for improved functionality to dynamically display the details of the top N items in a bar chart and group the remaining items as "Others" based on a specified criteria.

Currently, the existing features in Spotfire provide some options for achieving this, but I believe that additional capabilities or enhancements in this area could greatly improve the user experience and analytical flexibility.
My current workaround is like this: create a ranking column with the initial criteria that i need, for instance: DenseRank(Sum([Sales]) OVER ([Product)]),"desc",[Country]) and then use another calculated column for attributing Other like this: "case WHEN [Ranking]<5 then [Product] ELSE "Other" END".

It does the job but i'm wondering if something more dynamic (ie, working when using filters for instance) exist or could be set in place.

I would appreciate it if the Spotfire development team could consider implementing features that allow for more dynamic and flexible handling of sets, particularly in scenarios where users need to dynamically display top N items and group the rest.

I believe that such enhancements would greatly benefit users who rely on Spotfire for data visualization and analysis, and it would align with the growing need for dynamic and interactive data representation.

Thank you for considering this request, looking forward to any updates or improvements in this area :)