PDA

View Full Version : Pivot



brunocaccio
12-08-2005, 05:55 AM
I use PivotTable and there are several columns. I would like sort the columns.
I've tried with the button sort but it does not work.
Does anyone know to make that?

matthewspatrick
12-08-2005, 10:05 AM
Do you mean sorting the individual PivotItems within each PivotField, or sorting the PivotFields themselves (or both)?

To sort the items within a field, doubleclick on the field label in the PT, click Advanced in the field options form, and pick your autosort option.

Or do you need code? :)

brunocaccio
12-09-2005, 12:26 AM
Thanks for your answer. I've tried to sort (ascending) one column but I've not see the difference. Besides, I would like to know if we sort one column, the others columns follow the modification?

matthewspatrick
12-09-2005, 07:27 AM
Please upload a copy of your workbook, and describe precisely what you want to do be able to see.