Sort of Ranking is not working

[#1]

Hi,

I have done a table with a field defined as Ranking from 1 to 10 and I need to sort according this ranking, but nothing work.

I have 3 dimensions: T_Var (text), T_CName (text) and Rnk defined as:

=IF(Aggr(Rank(sum({$<T_Week={$(=Max(T_Week))}>}T_Amount)),T_Var,T_CName) <= 10, Aggr(Rank(sum({$<T_Week={$(=Max(T_Week))}>T_Amount)),T_Var,T_CName),Null())

Max(T_Week) = 201708

The expressions are sum(debt) for last 10 weeks.

And when I sort the dimensions, T_Var is ascending text, TCName is like gollowing print screen and Ranking doesn't have sort rule:

Can you help me, telling me why the result is not sorting by Ranking:

thanks

[sunny_talwar · Accepted solution]

This isn't perfect... but see the attached