right click a field in the first column
select field settings
click advanced

autosort
option : ascending
using field: Sum of qty



--
keepITcool
| www.XLsupport.com | keepITcool chello nl | amsterdam


Dennis Cheung wrote :

there are 2 fields in column area, they are class_name and
product_name. i need the sub-total of each class and sort by the
total of products in each category.
i tried to use the sort function in tools bar, it can sort only the
category which was selected. i needed to sort each class manully
after refresh the table.
can you help?

dennis