VBA to add PivotItems if it is a child of another PivotField/item

[Karter705]

Hey everyone, thanks in advance for your help on this.

I am not sure that I phrased this correctly in the title, which may be why I haven't been able to find an answer anywhere else. I am not sure if it is even possible.

Essentially, I have two lists -- one is Division, the other is Region; I am reading in the pivot items into two list boxes. When you select a division in the first list box, I want to add the pivot items for Region that belong to the selected Division into the second list box. Is this possible?

Something like:

Sheet3.RegionList.Clear

Set pt = Sheet7.PivotTables("ChartPivot")
Set pf = pt.PivotFields("Region")

For Each pi In pf.PivotItems
    If pi something should go here to check if it is in the selected division
            Sheet3.RegionList.AddItem (pi)
    End If
Next pi

Thanks again!

 

[gbardon]

I am interested in this as well, i believe it is something close to .parentitems()
Have you found a solution / alternative to this problem?

Thank you

BR
--
GMan