With out select SOURCE = WAGO & iTDS , how to make it display WAGO & iTDS line ?

[paulyeo11]

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

[paulyeo11]

My QV Dcc

[sunny_talwar · Accepted solution]

Try this:

sum({$<year = {">=$(=max(year),4)"}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}, COMPETITOR = {'WAGO', 'iTDS'}>}distinct REVENUE_C)/1000000

[paulyeo11]

Hi Sunny

thank you very much it work fine,.

PAul

[sunny_talwar]

Awesome