Need help on the setanalysis expression!

[#1]

Hi All,

I have an expression to give the count of units that are opened for grater than or equal to 15 days for the maximum period , maximum year, however I tried the same expression for the all periods up to the   selected period.[ For YTD]

my expressions are like below:

For Period

Count({<[UNIT]= {"=aggr(Sum({<Period={$(=max(Period))},YEAR={$(=max(YEAR))}>} [Net Sales] ),[UNIT])>=15"}>}[UNIT])

For Up to The Selected Period

Count({<[UNIT]= {"=aggr(Sum({<Period={"<=$(=max(Period))"},YEAR={$(=max(YEAR))}>} [Net Sales] ),[UNIT])>=15"}>}[UNIT])

In the above Formulas Period formula is returning count but Second formula not working can any one guide me where I gone wrong.

Regards

John

[#2]

Try this:

Count({<[UNIT]= {"=aggr(Sum({<Period<={$(=max(Period))},YEAR={$(=max(YEAR))}>} [Net Sales] ),[UNIT])>=15"}>}[UNIT])

[#3]

No Its Not Working