Hello All, I am trying to find the users with maximum cost value.

[Anonymous]

User	Cost Points	RU	BU
Angeli	6	21	Ed
Bomil	7	43	Pu
Angeli	0	22	Ed
Angeli	6	21	Mor
Rocky	7	34	Th
Moni	0	20	Tu
Rocky	6	35	Th
Aackerman	5	34	Tu
Angeli	5	23	Mor
Aackerman	6	34	Mor
Angeli	8	21	Mor

Here, I want to find the users with maximum cost points irrespective of RU and BU. If a user has a single entry in the table with 0 cost point, so he should also appear in the list. So my output should be the following

User	Cost Points	RU	Header 4
Angeli	8	21	Mor
Bomil	7	43	Pu
Rocky	7	34	Th
Moni	0	20	Tu
Aackerman	6	34	Mor

Code I am using is:

Load Distinct

"User Name",

RU,

BU,

Std_License,

Max("Cost Points") as "Max_cost_user"

Resident Combined_data

Where "Dialog_Users"=1

Group By "User Name",RU,BU,Std_License

Order By "User Name","Cost Points" ;

But it is not producing desired result.

I would highly appreciate any help. Thank you in advance.

[sunny_talwar]

Would you be able to add the above data in an app using the above script. Little short on time right now, it will help me immensely.

[Anonymous]

Sunny, Thanks for your response. I tried doing one, but unfortunately I am not able to do it. Actually, the question I asked is a part of one big load script. I tried replicating the script but its not happening. It would be helpful if you just let me know the script which should work for my problem.

Thank you