Sort a rank

[#1]

Hi everyone,

I have a pivot table with one dimension = rank (1 to 10).

This rank =IF(Aggr(Rank(sum({$<Week={$(=Max(Week))}>}Amount)),Var,CName) <= 10,Aggr(Rank(sum({$<Week={$(=Max(Week))}>}Amount)),Var,CName),Null())

The order of dimensions is Var (No sort), CName sort by expression = sum({$<Week={$(=Max(Week))}>}Amount) , Rank (No sort).

However, ranking sort is not working.

any help????

Thanks

[vishsaggi · Accepted solution]

I am not sure there is something happening with your Customer Field? Check attached.

[#3]

Thanks a lot!!!