Hello,
I need to change the Report Filter of a chart made on a pivot table just like explained here
http://chandoo.org/wp/2011/04/27/update-report-filter-macro/
The only difference is that I need to allow multiple selection. Is it possible to do so?
Do you have any suggestion? I can't find the solution. I was just thinking to use a combobox to let the user select the items but then I don't know how to pass the values to the pivot table.
Thank you very much
Vale
I need to change the Report Filter of a chart made on a pivot table just like explained here
http://chandoo.org/wp/2011/04/27/update-report-filter-macro/
The only difference is that I need to allow multiple selection. Is it possible to do so?
Do you have any suggestion? I can't find the solution. I was just thinking to use a combobox to let the user select the items but then I don't know how to pass the values to the pivot table.
Thank you very much
Vale