Set Analysis question

[dennysetiawan]

Hi community,

I have an expression with set analysis like this:

sum({<[BRAND]={"=RANK(SUM({<[SALES]-={0}>}-[SALES]),4)<=10"}>}[SALES])

Then I want to put this analysis on that expression:

MONTHYEAR={'$(vMTD)'}

where vMTD =DATE(ADDMONTHS(NOW(),-1),'MMM-YYYY')

Can anyone help me what is the correct script of set analysis to cover the two expressions above?

Thank you

[sushil353]

Try:

sum({<[BRAND]={"=RANK(SUM({<[SALES]-={0}>}-[SALES]),4)<=10"},MONTHYEAR={'$(vMTD)'}>}[SALES])

[sunny_talwar · Accepted solution]

May be one of these:

Sum({<[BRAND] = {"=Rank(Sum({<[SALES]-={0}>}-[SALES]), 4) <= 10"}, MONTHYEAR={'$(vMTD)'}>}[SALES])

or

Sum({<[BRAND] = {"=Rank(Sum({<[SALES]-={0}, MONTHYEAR={'$(vMTD)'}>}-[SALES]), 4) <= 10"}, MONTHYEAR={'$(vMTD)'}>}[SALES])

or

Sum({<[BRAND] = {"=Rank(Sum({<[SALES]-={0}, MONTHYEAR={'$(vMTD)'}>}-[SALES]), 4) <= 10"}>}[SALES])

[susovan]

Try this expression,

sum({<[BRAND]={"=RANK(SUM({<[SALES]-={0}>}-[SALES]),4)<=10",MONTHYEAR={"=$(vMTD)"}>}[SALES])

[dennysetiawan]

Thank you Sunny.

The best answer is Sum({<[BRAND] = {"=Rank(Sum({<[SALES]-={0}, MONTHYEAR={'$(vMTD)'}>}-[SALES]), 4) <= 10"},MONTHYEAR={'$(vMTD)'}>}[SALES])