Post Author: schilders
CA Forum: Formula
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.