Find a min value

[#1]

Hello, i have a list of customer and value. I want find a customer and her min value. I have attached a photo with the my problem.

Thanks.

[sunny_talwar]

See this may be:

Expressions:

1) =FirstSortedValue(Customer, Aggr(Only(Value), Customer, Value))

2) =Min(Value)

[MK_QSL]

Create a Straight Table

Dimension

No Dimension

Expression

1) Min(Value)

2) FirstSortedValue(Customer, Value)

[MarcoWedel]

Hi,

another solution could be an expression like this:

=Only({$<Value={"=Value=Min(TOTAL Value)"}>} Value)

hope this helps

regards

Marco

[JonasValleskog · Accepted solution]

The simplest solution I can think of would look like this:

Dim:

Customer

Exp:

if(min(TOTAL Value)=min(Value),min(Value))

[#6]

Hello, thank for the answer. This code works only if there only one value minium. For example there is only A = 10. But if there is A = 10 and B = 10, it write only A = 10.

How works this code: $<Value={"=Value=Min(TOTAL Value)"}>

[HirisH_V7]

Hi,

In straight table ,

Dimension:

=if(match(Customer ,'B'),Customer)

-SupressNull

Expression:

=Min(Value)

Thanks,

Hirish