Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 |
Could you please try to put same expression into sort tab?
Cheers
Hi Thiago,
I put same expression into sort tab getting same above output
Could you please send us an example app?
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.
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
In that case you can specify the sort order by using Count(DISTINCT [Meeting ID]) in descending order: