3 Replies Latest reply: Apr 28, 2016 12:28 PM by Francisco Sotomayor Huerta RSS

    Storing the straight table's Total Mode of a column in a variable for later reference

      Say you have a straight table containg  multiple rows (using one dimension) and just one column (one expression). The formula used to arrive at the individual row values is complex [uses divisions, multiplications, set analysis]. The total of the column however is merely the sum of the rows and hence I'm setting the Total mode to "Sum of rows". Now I want this total (which appears in the top most row, above the first row) to be stored in a variable for use in other computations. How do I achieve this?

       

      Help much appreciated.

       

      Regards,

      Gopal