View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Dennis Cheung[_2_] Dennis Cheung[_2_] is offline
external usenet poster
 
Posts: 17
Default sorting in pivot table

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