Top 50 filters based on filters

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 example city top 50 city based on sales, quarter to 50 sales on that quarter etc,

Please help

(1) Answer