Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Hi,
You could try this one.
dual('Rank ' & Rank(Sum(Total)), Sum(Total))
Regards,
Janzen
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