1 Reply Latest reply: Jun 9, 2016 8:41 AM by Yeo Poh sai RSS

    In QS does it support Add Calculated Dimension ?

    Yeo Poh sai

      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.