15 Replies Latest reply: Nov 28, 2016 8:00 AM by Sunny Talwar RSS

    How to add a second total row in straight table?

    Nicolas Castro

      Hi,

       

      I have a simple question and I can't seem to find the solution. I have a straight table with a single dimension and a few expressions.

      I also added a column with the sum of the values of the three columns, and a total row at the bottom. The table looks something like this.

       

      Dim     E1     E2     E3     Total

      A         10     15       5      30

      B          8       3       4       15

      C          7       4      14      25

      Total     25      22     23     70

       

      I need to add another row underneath the total row with the relative value of the total of each expression. Something like this.

       

      Dim     E1     E2     E3     Total

      A         10     15       5      30

      B          8       3       4       15

      C          7       4      14      25

      Total     25      22     23     70

      %         36%   31%  33%  100%

       

      Is this possible? Is there a simple way to do it?

       

      Thank you very much