Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I want to shwo the second max value in the title.
To get the dimension, i've :
=Only(if(aggr(
Rank(Count(if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1) )
/
Count(Total if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1) )
,Revenu_T1
),Revenu_T1)
=2,Revenu_T1))
that's fine, but i also want the value ...
I tried many things but without success ...
like
pick(2,
Rank( (Count(if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1) )
/
Count(Total if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1) ))
,Revenu_T1 ) )
thanks for your help.
How about this
=Max(Aggr(
Count(If($(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE, Revenu_T1))/
Count(TOTAL If($(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE, Revenu_T1))
, Revenu_T1), 2)
hello
tou could try to use
FirstSortedValue()
FirstSortedValue ([ distinct ] value, sort-weight [, rank ])
and specifying rank as 2
How about this
=Max(Aggr(
Count(If($(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE, Revenu_T1))/
Count(TOTAL If($(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE, Revenu_T1))
, Revenu_T1), 2)
Hi,
Try max(filedname,2)
hope this helps
Thanks Sunny, that's right !!!!
i tried it but unsuccessfully
Can you provide sample data or sample application to work on?