Modifying Pivot Tables : PivotTable « Excel « VBA / Excel / Access / Word

Modifying Pivot Tables

Private Sub OptionButton1_Click()
    Application.ScreenUpdating = False
    With ActiveSheet.PivotTables(1).PivotFields("Month")
        .PivotItems("Jan").Visible = True
        .PivotItems("Q4").Visible = False
    End With
End Sub


Related examples in the same category

1.Create Pivot Table From database
2.Creating a PivotTable Report
3.PivotTables Collection
4.Assign a value to the Orientation property of the PivotField object, as shown here:
5.Redefines the layout of the fields in the existing Table, apart from the data field
6.Add data field to PivotTable
7.Visible Property
8.add calculated items to a field using the Add method of the CalculatedItems collection
9.remove the CalculatedItem by deleting it from either the CalculatedItems collection or the PivotItems collection of the PivotField:
10.adds a PivotTable based on the data from an Access database