win32com - how to check if a value exists in a pivot table before filtering for it?

Question

I have tried multiple ways as below but none of them working for me.

1. I am getting not iterable error

for pivot_item in PivotTable.PivotFields("IN-PRODUCT-GROUP-CODE"):
    print(pivot_item.Name)

2. If value not present in pivot table throwing exception

   for fld in product_grp_cd_filter:
            if PivotTable.PivotFields('IN-PRODUCT-GROUP-CODE').PivotItems(fld).Visible:
               PivotTable.PivotFields('IN-PRODUCT-GROUP-CODE').PivotItems(fld).Visible = False
   

3. getting Count method not present error

   PivotTable.PivotFields('IN-PRODUCT-GROUP-CODE').Count
   

Answer 1

等待大神答复