Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Rank

Hi,    I am trying to rank  a list of clients by the gross premium   I have a table with the names of clients and theyre gross premium, when I add the rank in the table the rank works correctly ...
Anonymous's avatar
Anonymous
Not applicable
3 years ago

 

 

 

On the Card visual I have filtered for a client but I am getting the rank as 9 but on the table it is showing the rank as 8.

 

The formulae used is rankx(all(client),value(gross premium)

 

I have tried using Allselected in the formula but this just gives a rank as 1

 

Would really appreciate any solutions,

 

Thanks,