sorting in pivot table

  • Thread starter Thread starter Dennis Cheung
  • Start date Start date
D

Dennis Cheung

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
 
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 :
 
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
 
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 :
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table drill down sort 0
vba pivot table sorting 1
Sort Pivot Table by Gran total automaticaly 2
sort in pivot table 2
(repostX2) Pivot table: Grouping first row field by fifth row fiel 3
(Repost) - Pivot table: Grouping first row field by fifth row fiel 5
Worksheet sorting code/technique advise 55
Pivot Table 2

Back
Top