6 Replies Latest reply on Nov 11, 2016 10:18 AM by Naga Vemprala

    How to perform "Summarize Totals except top 3 rows"?

    Naga Vemprala

      I have data something like below for the name of person and the total sales he/she made:


      ABC1    34
      ABC2    45
      ABC3    78
      ABC4    79
      ABC5    23
      ABC6    61
      ABC7    34
      ABC8    54
      ABC9    90

       

      I have to display the dashboard as below, top 3 sales guys and the overall total sales made by rest of the team as ROT which is 498 - (90 + 78 + 79) = 251 team:

       

      ABC9    90
      ABC4    79
      ABC3    78

      -------------------------

      ROT    251

       

      For the top sales made, I gave a filter by sales person name, with Limit condition as "Top 3". But I am struggling to display the ROI even in a separate worksheet. Any help is appreciated.