Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Is there a sample you can share to look at the issue?