Crystal Reports Cross-tab Sort?

[Former Member]

Hello,

I am new to Crystal Reports and I canu2019t figure out how to sort a column on a cross-tab.

How can I sort in descending order the Total columns on a Cross-tab? E.g. will like to show the Product Names by the total amount of sales and not by alphabetical product name.

Rows: Product Name

Columns: Region

Summarized field: Total Sales (this is the column I will like to have in descending order)

If this cannot be done, what is the best way to solve this issue?

Thanks!

[Former Member · Accepted solution]

Hi Sorell,

I tried this, I right clicked on the table border, and clicked group sort, For this group sort I choose All and selected the measure amount and descending. This sorted amount table by the total column for me based on the highest product revenue.

Hope this helps

Regards

Alan

[Former Member · Accepted solution]

Genius!

Thank you Alan