Private Sub Worksheet_Activate()
Dim A, i
A = Array("银行存款", "库存现金", "固定资产累计折旧", "固定资产", "财政拨款收入")
For i = 0 To UBound(A)
Me.PivotTables(1).PivotFields("1级科目").PivotItems(A(i)).Position = i + 1
Next
End Sub
'排序
Sub px()
Dim A, i
A = Array("银行存款", "库存现金", "固定资产累计折旧", "固定资产", "财政拨款收入")
For i = 0 To UBound(A)
activesheet.PivotTables(1).PivotFields("1级科目").PivotItems(A(i)).Position = i + 1
Next
End Sub