Skip to Content
author's profile photo
Former Member

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.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

1 Answer

  • author's profile photo
    Former Member
    Posted on Oct 01, 2007 at 04:07 PM

    Post Author: foghat

    CA Forum: Formula

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

    Add comment
    10|10000 characters needed characters exceeded