Problem with firstsortedvalue

[tomhovens]

Hey All,

I'm looking for the first date with the max occupancy. The table with the input is;

Itemnr	Date	Occupancy
A	1-1-2016	200
A	2-1-2016	220
A	3-1-2016	220
A	4-1-2016	200
A	5-1-2016	180
B	1-1-2016	150
B	2-1-2016	175
B	3-1-2016	180
B	4-1-2016	180
B	5-1-2016	170

What I'm looking for is

Itemnr	Date	Occupancy
A	2-1-2016	220
B	3-1-2016	180

Function does work for itemnr with only 1 date with the max occupancy. Function so far is;

Firstsortedvalue(Date,-Aggr(sum(Occupancy),Date)

[Anonymous]

Hi Sunny,

          In the above expression, I couldn't understand the below part alone

     Date/1E6