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.
You could try this one.
dual('Rank ' & Rank(Sum(Total)), Sum(Total))
It's not working. I am getting values like
Total column expression is
Where QryType is Text Value
Retrieving data ...