Hi All
I using button to select only 4 company :-
COMPETITOR
(WAGO|PRECICON|iTDS|TDS_G|INTERMECH)
I need to insert filter expression into below SET expression :-
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}distinct REVENUE_C)/1000000
My approach :-
In the past i can insert filter less then current year.
money((Sum({<year = {"<=$(=Year(Today()))"}, $(ColumnDim51)={$(ColumnDim51)}>} Amount)/$(Columndim89)/1000), $(vMoneyFormatK))
So i assume expression as below :-
sum({$<year = {">=$(=max(year),4)"},COMPETITOR='WAGO'and'PRECICON', month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}distinct REVENUE_C)/1000000
But not work.
Paul
