8 Replies Latest reply on Apr 14, 2018 3:27 AM by Tariq Ansari

    Limit Rows in a view?

    Tariq Ansari

      I have a simple table view, with Customer Names and their Transaction Counts. I want to show only the Top 20 at any time.

      There are other filters like category and country, all of the data is linked. When I choose a country, the table view has to

      show the Top 20(or less) of that country. If no country/category is selected it shows the overall top 20.

       

      Right now I have just used filter on my Cuetomer Name : Filter - > Top -> By Field -> [Top 20 by sum(TransactionCount)].

      This works ok when nothing is selected, but when i select a country or category, it works on the Top 20 already selected and

      does not recalculate.

       

      How do I do it ?