16 Replies Latest reply: Mar 24, 2014 7:55 AM by Prashant Sangle RSS

    Total in Straight table row wise


      I have a straight table where i want to show Row wise Total.

      In Dim i have few strings like


      Dim                                  Expr(Count)

      Product1 Source                    55

      Product2 Source                  150

      Product Target                       10

      Product1 Target                      25

      Product2 Target                      25

      Product3 Source                     30


      What i want is Just two fields in Dim and Expr as


      Dim                        Total

      Source                    235

      Target                       60


      I used set analysis though but not getting what i expect..