Rank() based on frequency & Formatting?

[richardouellett]

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?

 

[sunny_talwar]

May be this:

Aggr(NODISTINCT Rank(Process), Process)

[richardouellett]

Sunny that fixes the numbering format but the ranking based on frequency is not adding up?

[sunny_talwar · Accepted solution]

Sorry about that, try this:

Aggr(NODISTINCT Num(Rank(Count(Process), 4)), Process)

[richardouellett]

Sunny thanks so much, that did the trick!