use running total in straight table

Thu, 21 Apr 2016 12:54:52 GMT

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

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.

Re: use running total in straight table

sunny_talwar — Thu, 21 Apr 2016 15:31:56 GMT

Is there a sample you can share to look at the issue?