max monthyear in calculated dimension

[khalander]

Hi,

I have written below expression in calculated dimension to get max month year but getting all months in dimension.

=aggr(max(monthyear),monthyear)

Please do the needful.

Regards,

Khalander

[Clever_Anjos]

include set analysis into your expression

Sum({<monthyear={"$(=Max(monthyear))"}>}Value)