I currently have a situation where i have a list of pivotitems that my macro has recorded I want filter that start date today
Now I have code as below.
Please guide me for solve it.
Thank you.
Now I have code as below.
Sub Macro7()
ActiveSheet.PivotTables("PivotTable27").PivotFields("CREATE_DATE").CurrentPage _
= "(All)"
With ActiveSheet.PivotTables("PivotTable27").PivotFields("CREATE_DATE")
.PivotItems("01/05/2024 9:11").Visible = True
.PivotItems("01/05/2024 10:01").Visible = True
.PivotItems("01/05/2024 15:01").Visible = True
End With
Please guide me for solve it.
Thank you.