cancel
Showing results for 
Search instead for 
Did you mean: 

Descending Sort of Data in CrossTab

Former Member
0 Kudos

Post Author: schilders

CA Forum: Formula

Good Morning,

I have created a crosstab that contains three columns for separate reporting periods and CPT code in the row field. The crosstab looks very nice, but sorts ascending on CPT code.

Can someone suggest how I can format the report such that the grand total (qty) is sorted in descending order? That is, I'd like the crosstab to sort so that the CPT code that has the most qty in total for all 3 reporting periods is at the top of the report.

Thanks, in advance, for your help.

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Post Author: foghat

CA Forum: Formula

See if this will work for you: http://technicalsupport.businessobjects.com/cs/forums/thread/7937.aspx