VBA filter columns of pivot table.

Hello friends! Hope 2017 is good to you all!

I have the following code; it filters the column and shows the results of Sep-16. I am also trying to display the column “Oct-16”.

But, Oct-16 is not appearing. Please help and thanks a lot in advance!

Sub FilterPivotTable()
Application.ScreenUpdating = False
ActiveSheet.PivotTables("test").ManualUpdate = True

ActiveSheet.PivotTables("test").PivotFields("months").ClearAllFilters

ActiveSheet.PivotTables("test").PivotFields("months").PivotFilters. _
Add Type:=xlCaptionEquals, Value1:="Sep-16", Value2:="Oct-16"



ActiveSheet.PivotTables("test").ManualUpdate = False
Application.ScreenUpdating = True
End Sub