Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
You cannot use Set Analysis for this.
Instead, use
=Only(Aggr(If(cost=Max(total <customer> cost),office),customer, office))
HIC
You cannot use Set Analysis for this.
Instead, use
=Only(Aggr(If(cost=Max(total <customer> cost),office),customer, office))
HIC
In your specific setting, also this may work:
=FirstSortedValue(office, -cost)
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