Excel Pivot Table

[Yan He]

I need to sort data (say by decending) in each sub-group in the table. But I couldn't figure out how to do it ...I've try Sort and Top 10 in PivotTable Toolbar, but it turens out that I can only do it manually.:smt100:smt100

 

[Andy Nguyen]

Pivot Table is extremely flexible and powerful so you should be able to manipulate data anyway you want. Your question is little vague. Maybe you can put a table here with some sample data and how you want to sort specifically so other members can give some input.

 

[sandeep]

Pivot tables

Yan
Indeed pivot table is an excellent tool to sort and manipulate data. If you want to automate certain task in pivot table, you could write a macro for that. The best way would be to record a macro for the action you want to automate and then customize that macro accordingly.
In case you need any help with this, you can message me.

Sandeep

 

[Yan He]

Thank you guys....I will try to put on a table later.

 

[jackgopher]

Have a look at the third video named "Useful features of pivot tables", which deals with sorting and filtering pivot tables, on the following address (it gives some good demonstrations of this issue):

pivot table