Rank function problem

[#1]

Can any one please help me in this

I have text column 'QryType'

In pivote chart last column show total of 'QryType' group by Source of Query.

Now I want to show details according to desc order of total.

I used rank function on total column but it showing value in range.

[#2]

Hi,

You could try this one.

dual('Rank ' & Rank(Sum(Total)), Sum(Total))

Regards,

Janzen

[#3]

It's not working. I am getting values like

Rank174-225

Rank20

Rank33-34

Rank129-151

Rank13-15

Total column expression is

=TextCount(QryType) 

Where  QryType is Text Value