Pivot

[brunocaccio]

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]

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]

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]

Please upload a copy of your workbook, and describe precisely what you want to do be able to see.