Set Analysis Expression Not Working

[Anonymous]

What is wrong with my expressions?

why does it show total sales for the entire model?

I can use YearMonth for the Max Month, and it works fine, but I can't for the Prev Month Expression, because it is looking for last year and my model is only for a single year.

What can I do??

MAX MONTH

sum({$<Month={$(=Max(Month))},

Year,

Quarter,

Month>}Sales)

PREVIOUS MONTH

sum({$<Month={$(=Max(Month)-1)},

Year,

Quarter,

Month>}Sales)

[#2]

Hi Chris, ¿did it work?