Home > IT Answers > Microsoft Windows > Order column in pivote table from vba
Emoraleshn
5 pts.
 Order column in pivote table from vba
Microsoft Excel 2007, VBA
I need help to make this, i try with PT4.PivotFields("Category").AutoSort xlDescending, "Ventas"

but not sorting.

Please helpme,

 

       With ActiveSheet.PivotTables("PivotTable5").PivotFields("Ventas")        .Orientation = xlDataField        .Position = 1        .Function = xlSum        .NumberFormat = "#,##0"        .Caption = "Sum Of Ventas"              End With               ActiveSheet.PivotTables(PivotTable5).PivotField("Category") _      .AutoSort xlDescending, "Sum Of Ventas"     

 



Software/Hardware used:
Excel 2007
ASKED: March 28, 2012  7:15 PM
UPDATED: March 28, 2012  7:43 PM
RELATED QUESTIONS
Answer Wiki:
Last Wiki Answer Submitted:  Be the first to answer this question.
All Answer Wiki Contributors:  Be the first to answer this question.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _