how to get Rank

[Anonymous]

Hi Experts,

I am using Rank function but rank coming but rank coming below

I am using the below logic

  =Aggr(Rank(Count(DISTINCT([Meeting Id]))),[Client Name])

Rank
2037-2153
3512-4826
2154-2302
3512-4826
3512-4826
863-877
3512-4826
2473-2684
986-1006
710-722
391-394
1171-1206
1066-1093
2037-2153
2685-3011
2685-3011
1352-1387
2037-2153
3012-3511
2303-2472
682-694
957-985
1936-2036
839-862
752-769
2303-2472
3512-4826

[Thiago_Justen_]

Could you please try to put same expression into sort tab?

Cheers

[Anonymous]

Hi Thiago,

I put same expression into sort tab getting same above output

[Thiago_Justen_]

Could you please send us an example app?

[petter]

Your expression works perfectly well and sorts according to rank in a normal table for me with my test data. Can you tell exactly what kind of table you are using the expression in and the dimension(s)?

The expression should not be in a calculated dimension but in a measure by the way.

[Anonymous]

Hi Petter ,

That expression working fine but that rank coming miss order like below

Rank

1

4

5

122

44

33

..

Like that

How to get sort is rank is question in Pivot table

[petter]

In that case you can specify the sort order by using Count(DISTINCT [Meeting ID]) in descending order: