So, if I understand you correctly, you have a cross-tab for each customer. Your boss wants you to sort the customer data descending by the total value each customer has purchased. Is this correct?
If so, you'll group by customer only - your year and month groups should be handled by the crosstab itself. Then do the following (this assumes that you're using Crystal 2008 or 2011 - I don't have a copy of any earlier version to see if this will work there...):
1. Create a summary at the customer level for total sales.
2. Go to the Report menu and select "Group Sort Expert".
3. In the expert, select the total sales summary that you created in step 1. Then select "Descending" sort.
This should give you what you need.
-Dell
IP Logged
