Forum Discussion

Anonymous

Not applicable

5 years ago

Rankx producing incorrect order

Hello, I am trying below calculated column in my dataset to return a rank to limit my bar chart Custom Col Cancellation Ranks = Var RankByCancellation= RANKX( All(MyPT_Cancellations), ...

Anonymous

Not applicable

5 years ago

Tried both format but still doesnt worked

Anonymous

Not applicable

5 years ago

Please guide how can remove dense rank and give separate rank if the value is same for the cancellation reason, I am doing top 19 + 20 (Other)

So, in this case rather than having 12 rank for more than 1 record I want serial rank no matter if the values are same.

I tried removing dense but the result show 1 and then 20 for all