Set analysis Query

Thu, 16 Aug 2012 11:36:54 GMT

Greetings All,

Can anyone please tell me how to write

IF(Expression= Quantity,SUM(AGGR(SUM(Qty),invoiceno,orderquantity)),

IF(Expression = Unit, SUM(AGGR(SUM(Unit),invoiceno,orderquantity))

)

in a pie chart where the dimension is the expression.

Expression is a field.

Expression

-----------------

Quantity

Unit

Quantity%

Unit%

Many Thanks!

Re: Set analysis Query

Jason_Michaelides — Thu, 16 Aug 2012 11:56:40 GMT

Maybe try putting the IF() inside the Aggr():

AGGR(SUM(IF(Expression='Quantity',Qty,Unit)),invoiceno,orderquantity)

Hope this helps,

Jason