Forum Discussion

sandrasanchez's avatar
sandrasanchez
Icon for Advocate I rankAdvocate 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

sandrasanchez's avatar
sandrasanchez
Icon for Advocate I rankAdvocate I
10 years ago

the second argument is already a measure

thanks

sandrasanchez's avatar
sandrasanchez
Icon for Advocate I rankAdvocate I
10 years ago

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

thanks so much!!