79182077

Date: 2024-11-12 17:09:20
Score: 1
Natty:
Report link

This seems to work. I am unsure why my PivotFields name and Items are with the [].

Sub Filter_Single_Item()
   Dim pt as PivotTable, pf As PivotField, ws As Worksheet
   
   Set ws = ThisWorkbook.Worksheets ("Sheet1")
   Set pt = ws.PivotTables("pvt_1")
   Set pf = pt.PivotFields("[Table1].[filter1].[filter1]")

   pf.ClearAllFilters

   pf.VisibleItemsList = Array("[Table1].[filter1].&[item1]")
End Sub
Reasons:
  • Has code block (-0.5):
  • Self-answer (0.5):
  • Low reputation (1):
Posted by: Coco Palafox