6 Replies Latest reply on Jul 26, 2018 11:39 PM by Naveen B

    Finding Top 10 Cities when using multiple filters

    Amit Darak

      Hi,

       

      I am trying to work on a problem where I have to find Top 10 cities by any one parameter in this case I have used Number of records.

       

      Now I have applied multiple filters like Profit, Category, Quantity. In my real problem there are more than 10 such filters.

       

      Now when I change any filters, Top 10 cities should also change accordingly. But it does not. In my data I have more than 5000 companies list and almost 10 filters and I want to find top 10 companies by revenue, employee count, profit.

       

      Any idea how to solve this.

       

      Also is it possible to have top 10 by multiple dimensions in 1 single sheet.