Jan 28, 2004 #1 Rae03 IS-IT--Management Jun 19, 2003 36 NL Is there a way to sort by subtotaled amounts on a excel spread sheet?
Jan 28, 2004 #2 S SkipVought Programmer Dec 4, 2001 47,487 US Rae03, Use the PivotTable Wizard using the Sum of... selection for the DATA AREA. Open the Field Settings of the ROW DATA field and select the Advanced Button. AutoSort Descending Using Field Sum of... PivotTable: Conquoring the demons of data, one query at a time ;-) Skip, http://www.TheOfficeExperts.com Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 Upvote 0 Downvote
Rae03, Use the PivotTable Wizard using the Sum of... selection for the DATA AREA. Open the Field Settings of the ROW DATA field and select the Advanced Button. AutoSort Descending Using Field Sum of... PivotTable: Conquoring the demons of data, one query at a time ;-) Skip, http://www.TheOfficeExperts.com Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884