Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi
I am trying to format rank in the attached example, as well as have the rank reflect frequency and that it shows the actual rank 1 - 4 instead of the stating row number, e.g., 1 would remain 1 and 39 would reflect rank 2. Seem like CAOR should have been ranked # since it had a frequency of 8? Can you assist?
Sorry about that, try this:
Aggr(NODISTINCT Num(Rank(Count(Process), 4)), Process)
May be this:
Aggr(NODISTINCT Rank(Process), Process)
Sunny that fixes the numbering format but the ranking based on frequency is not adding up?
Sorry about that, try this:
Aggr(NODISTINCT Num(Rank(Count(Process), 4)), Process)
Sunny thanks so much, that did the trick!