Get the date with the max of my metric

[#1]

Hi,

ok, I'm confused today... I need to get the day where there is the max no of sales by Areas

Data

Sales ID	Area	Date
1	South	01/01
2	South	01/01
3	South	02/02
4	North	03/03
5	North	01/02
6	North	03/03

Output

Area	Highest sales Date
South	01/01
North	03/03

I'm sure, it will appears obvious to some of you.

[sunny_talwar]

May be like this:

Dimension

Area

Expression

FirstSortedValue(Date, -Aggr(Count([Sales ID]), Area, Date))

[#3]

You are perfect !!! you rock. thanks a lot

[#4]

ok,

what if I need to put it in the dimension... it's working as an expression but not as a dimension.

[sunny_talwar · Accepted solution]

You can try this for a calculated dimension:

=Aggr(FirstSortedValue(Date, -Aggr(Count([Sales ID]), Area, Date)), Area)

[#6]

thanks a lot!!!