Forum Discussion

sandrasanchez's avatar
sandrasanchez
Advocate I
10 years ago
Solved

rankx

Hi,  I have a column of hospital names and in another column the sales in each hospital, I want to have a rank of hospitals and I have this measure: Rank ventas Hospitales = RANKX(All(da_Ventas_vs_...
  • Baskar's avatar
    Baskar
    10 years ago

    Hi,

     

    1. Have to create seperata measure

    Eg: Sum of Total Ventas Actual Pop = Sum(Total Ventas Actual Pop)

     

    2. Create Rank

    Eg: Rank = RankX(AllSelected(CNH & hospital),"Sum of Total Ventas Actual Pop",,DESC,Dense)

     

    It will solve your prob , if not let me know

Anonymous's avatar
Anonymous
Not applicable
10 years ago

Hello Sandra,

 

The second argument must be a Measure or must be surrounded by a CALCULATE() function.

 

Si quieres lo comentamos en castellano.

 

Saludos

sandrasanchez's avatar
sandrasanchez
Advocate I
10 years ago

the second argument is already a measure

thanks

  • sandrasanchez's avatar
    sandrasanchez
    Advocate I
    10 years ago

    If i put a calculated column I get an error....

    thanks so much!!