2 Replies Latest reply on Nov 2, 2017 8:57 AM by venkatram

    Required logic to calculating top n total

    Kunal Suresh Prajapati

      I am trying to show top 10 markets using index() function and their respective sales beside them. Top 10 markets could change based on 7-10 filters used on the dashboard.

      When I add column 'Grand Total' it shows total of all markets ($952) and not the top 10 ($250).

       

      Top 10 Markets

       

      if you know the solution to show top 10 total please do share them.. Appreciate your help!

       

       

      Thank You,

      KP