issue with set analysis

[domiho123]

Attached example shows my problem with set analysis.

Basically, the expression

=MaxString({<cost = {"$(=Max(cost))"}>} office)

is not returning the expected value. It seems that in the straight table the dimension 'customer'  is not taken into account.

Please advice.

Dominique.

[hic · Accepted solution]

You cannot use Set Analysis for this.

Instead, use

=Only(Aggr(If(cost=Max(total <customer> cost),office),customer, office))

HIC

[swuehl]

In your specific setting, also this may work:

=FirstSortedValue(office, -cost)

[domiho123]

Thank you both for your swift help. Both solutions work and give me a better insight in how to this in the future.

The best,

Dominique