Top 50 filters based on filters

[Manjunath Jannu]

Hi all Spotfire expertise, Dr# spotfire ,

I have table with 9000 customer i have to limit the data table with top 50 Unique customer based on their sales

challenges is if select any filters it should show the top 50 of that filter for examplecity top 50 city based on sales, quarter to 50 sales on that quarter etc,

Please help

[Richard Pobi]

Right click your table > Properties > Show/Hide Items > Add > Column:Sales > Rule type: Top > Value 50