Found highest value with Max(), how to get that value's dim?

[paweln]

Hi all,

I have many machines. Most of them creates defects. I find the worst machine's result and create KIP.

Max(Aggr((expr), Machine),1)

but how to get that dimension to put it in the title?

Only()?

[anat · Accepted solution]

to get max sales :=Max(Aggr(Sum(Sales), Product))

to get max sales product:=FirstSortedValue(Product, -Aggr(Sum(Sales), Product))

[paweln]

Is this possible to use

=FirstSortedValue(Product, -Aggr(Sum(Sales), Product))

in Set expression?

Sum({<Field1={"=FirstSortedValue(Product, -Aggr(Sum(Sales), Product))"}>} Field2)

I get error