Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi
See the first sheet, straight table.Hope it helps
max( {<[Status]="S">} Call)
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...
Hi
Try like this,
=aggr(Max({<Status={'S'}>}Call),Status)
Tick suppress null values
No it doesnt work...and supress already i given but not works..
Thanks,
ganesh.
Hi
See the first sheet, straight table.Hope it helps
Thank U very much....