1 Reply Latest reply: Aug 16, 2012 7:56 AM by Jason Michaelides RSS

    Set analysis Query

      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!