Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Enclosed my QV chart which is work fine.