Skip to main content
Announcements
The way to achieve your own success is the willingness to help somebody else. Go for it!
cancel
Showing results for 
Search instead for 
Did you mean: 
anuradhaa
Partner - Creator II
Partner - Creator II

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

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.

1 Solution

Accepted Solutions
Not applicable

Hi,

See the attachment.

View solution in original post

3 Replies
Brice-SACCUCCI
Employee
Employee

Hi,

can you try FirstSortedValue(Origin, Prise) ?

Regards,

Brice

Not applicable

Hi,

See the attachment.

anuradhaa
Partner - Creator II
Partner - Creator II
Author

Thanks all.

That one solve my problem.

Thank you very much