1 Reply Latest reply: Sep 16, 2012 11:28 PM by 935407 RSS

    Sum of 2 aggregated Rows

    962029
      Hi,

      I have the following data as a result of my SQL. I have used GROUP BY CUBE

      Category Status Count
      A S 5
      A F 10
      A R 5
      A Tot 20
      B S 15
      B F 10
      B R 5
      B Tot 30

      I need to get the new row ST which is Sum of S and F status records for each Category. For Example.
      Category Status Count
      A S 5
      A F 10
      A ST 15
      A R 5
      A Tot 20
      B S 15
      B F 10
      B ST 25
      B R 5
      B Tot 30

      Can someone please help me solve this issue.

      Thank you very much.

      Edited by: 959026 on Sep 13, 2012 11:28 AM

      Edited by: 959026 on Sep 13, 2012 12:14 PM
        • 1. Re: Sum of 2 aggregated Rows
          935407
          You can use the pivot table view and add a new calculated item which is the sum of S and T.

          But this new row will not appear before R. I suggest that you insert another new calculated item which is R then check the hide details option.