1 Reply Latest reply: Jun 9, 2016 8:41 AM by PAUL YEO RSS

    In QS does it support Add Calculated Dimension ?

    PAUL YEO

      Hi All

       

      I have a chart work fine in QV , and when i try to create the same chart in QS.

       

      In QV I need to place the below expression at Dimension at Add Calculated Dimension :-

       

      =if(aggr(sum({<eXP={eXP}>}Amount*-1),EXP_TYPE) / aggr(sum(total <year> {<eXP={eXP}>}Amount*-1), $(ColumnDim101)) > 0.001, EXP_TYPE, 'OTHERS')

       

      I not sure where to place it in QS.

       

      Hope some one can share with me.

       

      Paul