Set analysis using only

[#1]

=

sum({<MonthendDate = {"<=$(=Only(MonthendDate))"}, MonthendDate = {">=$(=addmonths(=Only(MonthendDate),-12))"}>} XXNET)

I am having difficulty with a set analysis, I am trying to have a chart show the monthenddate selected and the 12 months going backwards. My expression is not working , wondered if anyone can see what is wrong.

Thank you

Adrian

[#2]

try the following

sum({<MonthendDate = {"<=$(=Only(MonthendDate))>=$(=addmonths(=Only(MonthendDate),-12))"}>} XXNET)

Nimish

[#3]

Unfortunately, your suggestion did not work either.

I have made a little example of sales for previous 3 months may you or someone else can help.

Regards

Adrian

[#4]

example attached

[Miguel_Angel_Baeyens]

Try

sum({<MonthendDate = {">=$(=addmonths(Only(MonthendDate),-12))<=$(=Only(MonthendDate))"}>} XXNET)

. Very similar but not the same. Do you have the same Monthend format in all records?

[#6]

Still not working see example

[#7]

See example

[Miguel_Angel_Baeyens · Accepted solution]

There's no example here...

[#9]

Thank you your expression works in my example document but I can not make it work in the document I am working on.

I have looked at the format of the MonthendDate and exported it to excel, the underlying date is a number with no rounding so I can not understand why it would not work.

Any more ideas?