Suppose i have 10 pivot table reports.
every month i need to select country field (for example) via drop down menu of pivot tables to generate different reports.
is there any way through which i select the country from single drop down list and all the 10 pivot tables automatically select that country in one go?
thanks in advance
every month i need to select country field (for example) via drop down menu of pivot tables to generate different reports.
is there any way through which i select the country from single drop down list and all the 10 pivot tables automatically select that country in one go?
thanks in advance