Max Customer Name

[vanderson009]

Hi Community,

I have below data,

Customer, Value

A, 20

A, 30

B, 10

B, 15

C, 40

I want to take max value by customer, then want to display from Customer name in text box from max table, like

A, 30

B, 15

C, 40

is the maximum values record. Now want to display max customer from max table like

C in Text box

Regards,

Villyee

[Anonymous]

Hi Villyee,

Yo show max by customer:

=MAX(TOTAL <Customer> Value)

Yo show the max customer:

=Only({<Value={$(=Max(Value))}>}Customer)

Regards!

[#3]

Hi,

Please see attached

[susovan]

Hi Villyee,

Its might be your requirement.

PFA for QVW file.

[yadav_anil782]

plz go  to this link -    Max Group By 2 fields

max and group by function will help in this .

[effinty2112]

Hi Villyvee,

This expression in a textbox

=concat(Aggr(Customer & ', ' & Max(Value),Customer),Chr(10))

will give you:

A, 30

B, 15

C, 40

=Concat({<Value={$(=Max(Value))}>}Customer,', ')

will return the customer with the highest value or if there is a tie it will return the names separated by a ','.

Regards

Andrew

[muthukumar77]

Hi,

You can use like this,

=MaxString({<Value={$(=Max(Value))}>} Customer)

[kamal_sanguri]

C in the text box or A.. If we do a group by A will have 50 value.. isn't it..?

Thanks,

-Kamal