aggr calculation on one dim but display it on another in straight table

[annabergendal]

I have a calculation that needs to be done aggregating on one key dimension.

This seems to work fine, til I want to display the calculation on another dimension.

=if

(

sum(aggr(Sum (Qty1), %Key))=0

and

sum(aggr(sum(Qty2), %Key))>sum(aggr(sum(Qty3, %Key))

,sum(aggr(Sum (Qty4), %Key))

,0

)

How can I display it on Group dim? I tried to add in the aggr expression but didn't work.

So in the table I would like it to say 13 as a total.

Also I would like to display this in a graph with Group as dim, without the key.

Attached example.

Thanks.

[kaushiknsolanki · Accepted solution]

HI,

Here is the expression.,

=sum(aggr(if

(

sum(aggr(Sum (Qty1), %Key))=0

and

sum(aggr(sum(Qty2), %Key))>sum(aggr(sum(Qty3), %Key))

,sum(aggr(Sum (Qty4), %Key))

,0

),%Key))

Regards,

Kaushik Solanki

[annabergendal]

Thanks!

Works perfect