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

[Anil_Babu_Samineni]

Try to use?

=aggr(max(TOTAL monthyear),monthyear)

[khalander]

Hi Anil,

It is giving max month year but not get correct values for maximum month

[Anil_Babu_Samineni]

Image please

[Clever_Anjos]

=aggr(max(monthyear),monthyear) will aggregated for every monthyear and calculating the max(monthyear), so that´s correct retrieving all monthyear

try with

max(monthyear)

[khalander]

Hi Anjos,

It is showing error in calculated dimension message if i am giving max(monthyear)

[Anil_Babu_Samineni]

Max() won't work in calculated instead why can't you write in expression and promote them to dimension place?

[tresB]

It should even work without aggr(), like max( TOTAL monthyear) . If your monthyear is a dual field, this expression should work; you might want to format it like = monthname(max(total monthyear))

[Clever_Anjos]

try with

=max(total monthyear)

[khalander]

Yes It is giving max monthyear if i used total word  but my expression values is coming total values instead of max month values