Check If Value Exists in PivotTable (as a PivotItem)

[EnigmaMatter]

Hello,

I have a PivotTable full of Customer data. When I select a Customer in the Report Filter/PageField, it shows me a list of products purchased.

How do I check the entire range of products purchased by that customer for a specific product? If the range does not contain that product name, it would show me a MsgBox saying "No.".