Modify the total of straight table

[#1]

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 4 expressions.

this is a YoY comparison.

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

[swuehl]

Try something like this in your expressions:

=If(Dimensionality()=0,

     YourPercentageIncreaseExpressionInTotalLine,

     YourDetailsLineExpression

)

[satishkurra]

Use the below expression

if(Dimensionality()>0,

sum(SalesAmount),

Num(sum(SalesAmount),'#,##0.00%'))

Set the expression to default in Number Tab

[satishkurra]

Sorry, i didn't see when replying the question, i see after submitting, Apology

[swuehl]

No problem, that happens quite often because it's hard to see if there are replies coming in while typing.

Keep on Qliking...

[#6]

This group is awesome.

[#7]

That works, i tested with the values hardcoded, but another issue that i have is that i am using calculated dimension. how can I refer it in expression.