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

    Total in Straight table row wise

    Gyanaranjan Tripathy

      Hi,

      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..

       

      Thanks.