In QS does it support Add Calculated Dimension ?

paulyeo11 — Thu, 09 Jun 2016 12:40:36 GMT

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

Re: In QS does it support Add Calculated Dimension ?

paulyeo11 — Thu, 09 Jun 2016 12:41:36 GMT

Enclosed my QV chart which is work fine.