Thread: Select One Item PivotTable VB

I have a field called FIELD 1 which is dates. Every week a spreadsheet is imported to the sheet and adds dates to the item list. I want to select ONLY "blanks". Right now I see if I record my action it does a clear filter, and then turns visible to false for all Items, BUT I can not have this as each week new Items are added. So how do I only select the item "blanks".

I thought the easiest route would be turn off ALL then select "blank" as visible, but I do not know how to turn off ALL
thanks

Change the below code to reflect the correct values in your pivot -

Dim pi As PivotItem
    
For Each pi In ActiveSheet.PivotTables("PivotTable1").PivotFields("Field 1").PivotItems
    If pi.Value <> "(blank)" Then
        pi.Visible = False
    End If
Next pi