1 Reply Latest reply on Nov 11, 2016 2:44 AM by Hima vardhan Reddy Pavuluri

    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.