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

sorting in pivot table
 

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

sorting in pivot table
 

i followed your instruction, it sorted by sub-total of class.
i need it to sort by sub-total of products and the order of class doesn't
change.

Dennis

"keepITcool" wrote in message
ft.com...
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

sorting in pivot table
 

try again ..

sort the first column..
in the options be sure to dropdown 'using field'
and select the appropriate field

this is where the sorting is set and nowhere else.

if it fails.. experiment.


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


Dennis Cheung wrote :

i followed your instruction, it sorted by sub-total of class.
i need it to sort by sub-total of products and the order of class
doesn't change.

Dennis

"keepITcool" wrote in message
ft.com...
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