1 Reply Latest reply on Nov 16, 2018 8:11 AM by Norbert Maijoor

    Summing up others and show in single row along with top 5

    rao marapatla

      Hi All,

       

      I have a scenario which I wanted to show top and rest all are in one row as Others - i can able to get top and remains are as others now wanted to sum up all others and show in single row followed by top 5.

       

      please find attached workbook

       

      below is expected output

        

      _DisplayCitiesSales% Sales
      Bologna16,94132.35855904
      Florence13,45925.70768232
      Milan9,82518.76647439
      Verona7,10013.56152347
      Naples3,6947.055812354
      others1,3352.549948428