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)
