How can I filter a pivot table with three comboboxes?

%3CLINGO-SUB%20id%3D%22lingo-sub-2069205%22%20slang%3D%22en-US%22%3EHow%20can%20I%20filter%20a%20pivot%20table%20with%20three%20comboboxes%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2069205%22%20slang%3D%22en-US%22%3E%3CP%3E%3CSPAN%3EHello%20everyone%2C%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EI'm%20working%20on%20a%20dashboard%20on%20Excel%20365%2C%20in%20which%20I%20would%20like%20to%20learn%20how%20to%20add%20three%20combo%20boxes%20which%20should%20filter%20a%20Pivot%20Table%2C%20named%20%22Operations%22%20and%20placed%20in%20a%20Sheet%20also%20named%20%22Operations%22...%20Basically%2C%20this%20pivot%20table%20shows%20the%20name%20of%20the%20products%2C%20their%20respective%20operations%20and%20their%20work%20orders.%20I%20made%20three%20slicers%2C%20but%20what%20I%20would%20really%20like%20is%20having%20three%20dependant%20combo%20boxes%2C%20which%20can%20filter%20the%20pivot%20table%20by%20typing%20what%20I'm%20looking%20for.%20%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%3CSPAN%3EMore%20specifically%2C%20I%20would%20like%20to%20be%20able%20to%20type%20the%20name%20of%20the%20product%20and%2For%20the%20work%20order%20and%20find%20the%20operations.%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EAnother%20question%20inherent%20to%20this%20discussion%20is%3A%20would%20it%20be%20better%20to%20use%20Active%20X%20combo%20boxes%20of%20Form%20control%20ones%3F%20Is%20it%20even%20possible%20to%20type%20something%20into%20a%20Form%20Control%20combo%20box%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%3EI%20hope%20I%20expressed%20myself%20well.%20Please%20tell%20me%20if%20you%20don't%20understand%20something%2C%20I'll%20try%20to%20reformulate.%3C%2FSPAN%3E%3CBR%20%2F%3E%3CSPAN%3EThank%20you%20very%20much%20in%20advance!%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2069205%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EMacros%20and%20VBA%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2076598%22%20slang%3D%22en-US%22%3ERe%3A%20How%20can%20I%20filter%20a%20pivot%20table%20with%20three%20comboboxes%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2076598%22%20slang%3D%22en-US%22%3EHello%20guys%2C%20may%20I%20have%20some%20help%20please%3F%3C%2FLINGO-BODY%3E
New Contributor

Hello everyone,
I'm working on a dashboard on Excel 365, in which I would like to learn how to add three combo boxes which should filter a Pivot Table, named "Operations" and placed in a Sheet also named "Operations"... Basically, this pivot table shows the name of the products, their respective operations and their work orders. I made three slicers, but what I would really like is having three dependant combo boxes, which can filter the pivot table by typing what I'm looking for.

More specifically, I would like to be able to type the name of the product and/or the work order and find the operations.

 

Another question inherent to this discussion is: would it be better to use Active X combo boxes of Form control ones? Is it even possible to type something into a Form Control combo box?

 

I hope I expressed myself well. Please tell me if you don't understand something, I'll try to reformulate.
Thank you very much in advance!

1 Reply
Hello guys, may I have some help please?