Set Analysis

[kamal_sanguri]

Hi,

I have one inline table:

**********************************************************

Data:

Load *

Inline

[

Server, Usage

A,10

B,25

A,15

B,12

A,40

C,25

C,30

];

**********************************************************

Now, I want to see which server has the max usage. I want to do that in expression.

using max(aggr(sum(Usage),Server)), I can figure out the max usage of the server but how I can get the name of server.

Thanks,

Kamal

[Kushal_Chawda]

was my answer something different?

[Kushal_Chawda]

kamal_sanguri one suggestion , before you mark the correct answer just check if somebody has already replied or not and mark the correct answer who replied first

[sinanozdemir]

Just a thought. If you want to show only the server that has the highest usage, you can also use Rank() function in text box as below:

Thanks

[sunny_talwar]

Gussa nai bhai

[kamal_sanguri]

Fair point.. I just saw your first reply.. and when I saw the solution from someone else, I didn't realize that you have already responded.. I will make correction..

I just reached home and saw email notification that I have messed up things heavily..

-Kamal

[kamal_sanguri]

Sunny Bhai, Kushal ko gussa karne do.. it was my fault..

[kamal_sanguri]

sorry, unmarking it as correct.. Since Kushal responded first.. he is the one who should get the credit.. Marking your reply as helpful though.. hope you will understand..

[trdandamudi]

I have no issues... We all help each other....

[Kushal_Chawda]

kamal_sanguri I hope I was not too much rude. if so I apologize for that.  May be I had not structured my sentence well.

[Kushal_Chawda]

sunny bhai gussa nahi yaar..bas sentence thik tarah se likh nahi paya.. thoda  rude aur attitude types lag raha he.. sorry for that..