KPI max value and depending date

[igdrazil]

Hi there,

i got another problem. I have a KPI Value "Max(aggr(sum(pallets), time))" and for the second value on the same KPI i want the Date, when this value appears.

So e.g. max would be 15 and the date 1.1.2016.

I tried different things but it never worked... I am this far at the moment:

Max({$<Pallets = {'$(=Max(Aggr(Sum(Pallets), time)))'}>}time)

I think i may know the problem, which is that my part in {}-Brackets will give a sum and not a single Pallet number. Is there a way to filter for a sum in that part?

Thanks in advance!

Regards

Chris

[MK_QSL · Accepted solution]

FirstSortedValue(Time, -aggr(sum(pallets), time))

or

FirstSortedValue(Date, -aggr(sum(pallets), time))

[igdrazil]

Thank you! working fine and sooo much easier than my approach

Regards

Chris