1 Reply Latest reply: Apr 21, 2016 11:31 AM by Sunny Talwar RSS

    use running total in straight table

    Jagveer Dhillon

      Hi,

       

      I am trying to modify the totals of a straight table.

      Basically i have a straight table with one dimension(the dimension has only 2 values and it is a calculated dimension) and 4 expressions.

      this is a YoY comparison.

      instead of totals at the bottom i want the percentage increase as shown below

       

      Untitled.png

       

      I have used the below solution as suggested by swuehl

      =If(Dimensionality()=0,

          YourPercentageIncreaseExpressionInTotalLine,

          YourDetailsLineExpression

      )

       

      but i am stuck at that "YourPercentageIncreaseExpressionInTotalLine," is based on the "YourDetailsLineExpression" so how do i refer to that

      is there a runing total to be stored in variable or something on those lines.