Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I using button to select only 4 company :-
COMPETITOR
(WAGO|iTDS)
May I know how to insert the above filter expression into below SET expression :-
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>}distinct REVENUE_C)/1000000
so that i can use this chart in QS.
Paul
Try this:
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000
My QV Dcc
Try this:
sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000
Hi Sunny
thank you very much it work fine,.
PAul
Awesome