Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
I am not sure there is something happening with your Customer Field? Check attached.
Thanks a lot!!!