Pivot Table: I need the filter criteria to also show in my pivot

[wilster98]

I have a pivot table full of fictitious data. I need to filter by Company Name, but when I filter on multiple Customers, the Company name is not in the pivot, and I can't put company name in rows. Is there a way to do that?
Thanks in advance
Willy

 

[wilster98]

I have a pivot table full of fictitious data. I need to filter by Company Name, but when I filter on multiple Customers, the Company name is not in the pivot, and I can't put company name in rows. Is there a way to do that?
Thanks in advance
Willy

View attachment 60341

I figured this out by trial and error. Once the slicer is in place, "Customer" can be moved to Row Values, and Viola, my company name is filtered and displayed