How to get Sorting in Rank?

[Anonymous]

Hi Experts,

I have Rank Id 's in Calculated dimension in Pivot table .

How to get Rank wise sorting in Dimension level

Rank:

12

32

45

1

344

excapted out put is

Rank

1

12

32

45

344

[ashwinishinde]

Hello,

try this,

Properties -->Sort --> Expression --> =rank(Rank)

[Anonymous]

HI Shinde,

But here Rank is calculated dimension.

[ashwinishinde]

hello,

try this,

try same expression =rank(Rank)  for first dimension of pivot table.