How to modify the expression So that it still work when current month and year not selected

[paulyeo11]

Hi All

I have below expression working fine ( Ref to chart 1 ) , when year = 16 and month = 3 :-

sum({$<year = {$(=max(year))}, month = {"<=$(=max({<year={$(=max(year))}>} month))"}>} sales)/1000

May i know how to change the above expression still working , when year and month is not selected. So that i can use the same expression in QS. with out need to activate current month and current year.

Paul

[sunny_talwar · Accepted solution]

Try this expression:

sum({$<year = {$(=max({<sales = {'*'}>}year))}, month = {"<=$(=max({<year={$(=max({<sales = {'*'}>}year))}>} month))"}>} sales)/1000

[paulyeo11]

Hi sunny

Thank you vey much.

Paul