Second max value in title

[Anonymous]

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.

[olivierrobin]

hello

tou could try to use

FirstSortedValue()

FirstSortedValue ([ distinct ] value, sort-weight [, rank ])

and specifying rank as 2

[sunny_talwar · Accepted solution]

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)

[sagar_puri]

Hi,

Try max(filedname,2)

hope this helps

[Anonymous]

Thanks Sunny, that's right !!!!

[Anonymous]

i tried it but unsuccessfully

[bc-thebruuu]

Can you provide sample data or sample application to work on?