Hi All
I have below expression display YTD target amount is working fine :-
SUM({<year = {'$(=Max(year))'}, month = {"<=$(=IF(GetSelectedCount(month), Max({<year = {'$(=Max(year))'}>}month), Num(Month(Today()))))"}>}sales_target/Rate/1000)
usually i can make use of below expression to make it work :-
Sum({$< Month_n ={"2"}>} sales_target/1000)/Rate
But due to Month_n field is not link to sales_target , so i have to use SET analysis.
Hope some one can advise me.
Paul Yeo