Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try to use?
=aggr(max(TOTAL monthyear),monthyear)
Hi Anil,
It is giving max month year but not get correct values for maximum month
Image please
=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)
Hi Anjos,
It is showing error in calculated dimension message if i am giving max(monthyear)
Max() won't work in calculated instead why can't you write in expression and promote them to dimension place?
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))
try with
=max(total monthyear)
Yes It is giving max monthyear if i used total word but my expression values is coming total values instead of max month values