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

[Anonymous]

did you try to sort by expression:

Aggr(Rank(sum({$<Week={$(=Max(Week))}>}Amount)),Var,CName)

[#3]

It's no working

[vishsaggi]

can you share your sample to look into?

[#5]

attached my sample model, where you can see that rank is not ordered

Thanks

[#6]

attached my sample model, where you can see that rank is not ordered

thanks !

[Anonymous]

I think you have to promote the rank to the top of the sorting levels. Means rank must be the first dimension.

This is the way how pivots work. Everything is grouped and within one group (dimension) the next sorting will be applied.

[#8]

Nop. This not working... these happen when I promoted the rank to the top:

Help!!!

[Anonymous]

Did you set the sort order of "RNK" to numeric ascending?

Is RNK now on the top level of your sort order?

[#10]

In the print screen above rank is the first dimension and I loose the ranking by Variable...