3 Replies Latest reply on Sep 25, 2019 6:00 AM by Mavis Liu

    Sum of Categories with a dimension

    Jagadeesh Kumar Yogamoorthy

      HI All,

       

      My data goes like this ->

       

       

        

      ActivityNumber of Records
      A10
      B70
      C250
      D750
      E20
      F40
      G150
      H300

       

       

      I want the tabular format of display like

       

       

        


      ActivityNumber of Records
      C+G400
      G150

       

       

      Logic to be used is , I need  Sum(C) + Sum(G) as one row with the total sum value .
      Another row should show Sum(G) alone.

       

       

       

      Thanks,
      Jagadeesh