3 Replies Latest reply: Dec 11, 2017 3:53 AM by Jaspreet Sran RSS

    How to get 'Sum of Rows' in Text box instead of 'Expression Total' ?

    Jaspreet Sran

      Hi all,


      I have a Text Box to display the value for an expression like sum(A)*B, for any number of dimensions selected by the user.

      By default it is showing 'Expression Total', which is not giving correct results because of multiplication involved.

      I need to show 'Sum of the Rows' in the same.


      Data example :


      If D1, D2 and D3 are selected,


      Expression Total:   (10+12+13) * (2+3+4) = 35 * 9 = 315 (incorrect)

      Sum of Total: (10*2)+(12*3)+(13*4) = 108 (correct)


      Can anyone suggest a solution?


      Thanks in advance