Hi guys,
This can be a easy task but I couldn't find any suitable solution online.
I have a PivotTable ("pivotreport") with many fields like Clients, Projects, Products... In the same worksheet 2 comboboxes (clientfilter and projectsfilter) and a command button named "Filter".
I want to configure the code for the Filter button to perform the same action as the slicers do - filtering the table field according to the comboxes value. Is this a hard task?
Thank you in advance for any help!
Bookmarks