Skip to Content
Former Member
Sep 28, 2007 at 05:21 PM

Descending Sort of Data in CrossTab


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.