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

[sunny_talwar]

I understand it bro. I have been on there many times

[kamal_sanguri]

All well that ends well.. Happy Friday mate.. Cheers!!