Hi All
I have this expression from Mr Sunny :-
RangeSum(
Above(RangeSum(Above(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1/1000)), 0, RowNo()))),
-Sum(TOTAL Aggr(If([Exec P&L Level] = 's', '', Sum({<year, month>}[Amount]*1/1000)), YearMonth)))
It work fine in QS , but not my QV ver 9. As i remember before , when i plot chart if i remove RangeSum(Above
the chart may able to give the correct value.
Hope some one can share with me how to remove the RangeSum(Above from above expression.
Paul
