I add a grand total in my Crosstab report to get the Avg. at Column level. Now I want to sort based on grand total to see which field has highest Avg. I am using this grand total as key in sort property in crosstab but data is not sorting based on grand total.Report Design is attached.Please suggest some solution.
Can you upload an image of the output?
Take a look at the attached example that sorts on grand total.
Jason
On 5/29/2012 8:08 AM, Sameer Singh wrote:
> Hi
>
> I add a grand total in my Crosstab report to get the Avg. at Column level. Now I want to sort based on grand total to see which field has highest Avg. I am using this grand total as key in sort property in crosstab but data is not sorting based on grand total.Report Design is attached.Please suggest some solution.
>