set analysis error?

[#1]

Hi everyone,

I have created an exprssion where I want a row to show January's figures regardless of the month selection. the only reason that this should change is if the year changes. therefore using set analysis I have created the expression:

sum({<Master_Calendar_MonthYear={"=$(=yearstart(Master_Calendar_MonthYear))"}>} Value)

This however, doesn;t seem to work. If I do a simple yearstart(Master_Calendar_MonthYear) in a text box it gives the correct answer so I'ma little puzzled why it isn't working for the set analysis.
Can anyone see what is missing?
Thanks</body>

[googel84]

I would try with

sum({<Master_Calendar_MonthYear = {'$(=yearstart(Master_Calendar_MonthYear))'}>}Value)

I cancelled an "=" sign and used single quote instead of double.

Hope it helps.

[#3]

That just makes the table show no data at all unfortunately. thanks for the suggestion though.