Set analysis filter

[#1]

Status	Call
S	1
S	2
S	3
N	4
N	5

Here i need to get output as maximum value with status as 'S'.  so i am using set analysis... with

=only({<call={"$(=max(call))"}>}call).... i will get maximum value as 5...  as out put..

Status	Call
S	-
S	-
S	-
N	-
N	5

Now i tried =only({<Call={"$(=max(Call))"},Status={"S"}>}Call)....and   =only({<Status={"S"},Call={"$(=max(Call))"} >}Call)....but the my put is like below...

i didn't get any value..

Status	Call
S	-
S	-
S	-
N	-
N	-

and one more issue i am facing, tried to supress the Null values...then the out put must be

Status	Call
S	3

but it fails,,, i supressed every thing i need to do.. please telle me solution for the above suitation..

Thanks in advance...,

Ganesh.Avula.

[giakoum]

max( {<[Status]="S">} Call)

[#3]

max( {<[Status]="S">} Call) ---- i am getting out put as

Status	Call
S	1
S	2
S	3
N	-
N	-

i need only S -- 3..  i tried only(max( {<[Status]="S">} Call))  but the output is all Null...

and give me the solution for filtering the null value...

[MayilVahanan]

Hi

     Try like this,

     =aggr(Max({<Status={'S'}>}Call),Status)

     Tick suppress null values

[#5]

No it doesnt work...and supress already i given but not works..

Thanks,

ganesh.

[MayilVahanan · Accepted solution]

Hi

     See the first sheet, straight table.Hope it helps

[#7]

Thank U very much....