when you create a crosstab for columns, there is 'Group Options...' button under 'Columns:' box.
try to use this function.

(maybe you'll need to create formula to set as ColumnName).


hope it help.

I have not found any way that the Group Options can be set to sort on an individual column or row. It will sort on overall totals, but not on values in one particular row or column.

here is what i've done.

crosstab condition:
- Row : item desc
- Column : location desc
- Detail : qty on hand

till here, it gives me standard/normal crosstab (where the QtyOnHand is not sorted).

here is to sort the QtyOnHnd:
1. right click crosstab

2. select 'Cross-Tab Expert...'

3. click on field in Columns section ({tbl.QtyOnHnd})

4. click 'Group Options...' button

5. sort by {tbl.QtyOnHnd} and set as 'Descending'

6. click on 'Options' tab

7. check for 'Customize Group Name Field'

8. select for {tbl.LocDesc} in order to print the Location name



hope it help.




Edited by Emir_W - 25 Aug 2010 at 10:26pm