Finding matching dimension for min value

[rwunderlich]

I need a little help with this expression. (Example QVW attached). For two tables:

ShipmentId, Destination, Carrier
1, D1, B

Destination, Carrier, Rate
D1, A, 2000
D1, B, 2500
D1, C, 1500
D1, D, 1800

In a chart, I can find the lowest Rate for a ShipmentId with:

=aggr(min(Rate), Destination)

In the same chart, how can I display the Carrier associated with that lowest Rate? Somthing like:

ShipmentId	Destination	Carrier	Rate	Best Rate	Best Carrier
1	D1	B	2500	1500	C

Thanks

[#2]

Thanks John…

That’s a little simpler than computing it as I did.

Don