Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi Villyee,
Yo show max by customer:
=MAX(TOTAL <Customer> Value)
Yo show the max customer:
=Only({<Value={$(=Max(Value))}>}Customer)
Regards!
Hi,
Please see attached
Hi Villyee,
Its might be your requirement.
PFA for QVW file.
plz go to this link - Max Group By 2 fields
max and group by function will help in this .
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
Hi,
You can use like this,
=MaxString({<Value={$(=Max(Value))}>} Customer)
C in the text box or A.. If we do a group by A will have 50 value.. isn't it..?
Thanks,
-Kamal