Rank in pivot table

[brijesh1991]

Hi all,

I had 3 dimentions in a pivot table; I had used rank(sum(Amount)) expression to get rank; but while I am expanding each column of pivot table; rank is splited based on secondary dimention. It should not be splited.

In short, Rank should be based on 1st dimention only, rest of the dimentions should not be considered while ranking.(See the attached image)

Sample Data is attached.

All suggestions are welcomed.

Regards,

Brijesh

[Anonymous]

Brijesh,

The best I could do is to have rank as calculated dimension,

aggr(num(rank(sum(Amount),1)),Dim1)

and place it as the very first dimension, before Dim1.

Regards,

Michael