Pivot Table - show only when all filter criteria is present

Copper Contributor

Hi,

 

can you help me with the following, I have a large excel spreadsheet, I have created a pivot table on it, I have different codes, they have different types of movements, in the filter conditions I have specified what type of movements I want to see, but I only want the types of codes where all the movement types I have specified are found. Is there a simple solution to this?

 

excel1.PNG

2 Replies
Can you share a MockUp file?

@FikturFox Yes I have uploaded a mockup file, I would only like to see the entries where all A-B-C-E movement types are present.