Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crosstab need sort by Total Return Amount for each Item

I created a crosstab report by Item Number by return reason code for one year data with Total Qty Returned and Total RA Amount for each cell. I have Row Total and Column Total on top row and left column.

I want to sort this entire report by Descending order in Total Return Amount (Row Total's RA Amount).

Below: B125 should be the first then A001 the second..etc.

Item # Total , Defect, Ship Wrong , Chg Mind , BackOrder

Total 8 , 16 , 4 , 3

A001 21 , 5 , 12 , 3 , 1

$210 , $50 , $120 , $30 , $10

B125 10 , 3 , 4 , 1 , 2

$1,000 , $300 , $400 , $100 , $200

Or, export to Excel to sort the data there but the size is too big for one year. Any comment?

Edited by: Lily Chien on Sep 17, 2008 8:22 AM

Edited by: Lily Chien on Sep 17, 2008 8:27 AM

Edited by: Lily Chien on Sep 17, 2008 8:30 AM

Edited by: Lily Chien on Sep 17, 2008 8:31 AM

Not what you were looking for? View more on this topic or Ask a question