Get minimum values from a data set and display in straight table

[anuradhaa]

Hi,

Pls chk my attached xcl sheet. There i have prices to destination to origin with different suppliers.

So what i need to get is the minimum origins supplier wise.

exp 1 - =min({<Supplier={'A'}>}PRICE)

exp 2 = =min({<Supplier={'B'}>}PRICE)

and i have used destination as dimension.

i have use below expression and i can get the prise for it, but i can't include associated origin in that chart.

Plz help.

[Brice-SACCUCCI]

Hi,

can you try FirstSortedValue(Origin, Prise) ?

Regards,

Brice

[#3 · Accepted solution]

Hi,

See the attachment.

[anuradhaa]

Thanks all.

That one solve my problem.

Thank you very much