Writing an IF statement in a pivot table in Excel

I am trying to filter through our online orders that came through recently, as we had a huge influx of orders on our e-commerce site.

I have exported the data and created a pivot table based on the customer's name, their order number, and the type of item they purchased. We have a lot of out of stock items right now, so what I am trying to accomplish is the following.

If a customer purchased a type of item that is out of stock, I want to hide their order. My data looks like this:

John Smith

• Order #1
• Hat
• Shirt

Jane Doe

• Order #2
• Sticker

Since we are out of hats, I want the pivot table to ignore their order number so it only returns Order #2, etc.

I apologize if this is not clear enough, and if I need to provide more clear examples I will. Thank you in advance for your help.