2 Replies Latest reply: Jun 19, 2012 6:41 AM by Pratibha Kumar RSS

    Display top 'x' rows and sum others

    Dipesh Patel

      Hello,

       

      I have following data on straight table, i am creating a "list box" top 'x' rows and others should sum up.

      Straight table:

      FS732
      Tec30
      Me28
      Other25
      PS14
      Edu10
      Util6
      Auto5
      Con5
      Gov5
      Tel4
      Hea3
      Aer2
      Agr2
      Dive2
      Man2
      Retai2
      Hos1

       

      the result shoud come as follow:

      FS732
      Tec30
      Me28
      PS14
      Edu10
      Util6
      Others58

       

      can someone help me to get above result?

       

      Thanks