Hi Dieneba,

Slicers apply filters to PivotTables. The PivotTable Connections dialog enables you to specify which PivotTables you want that Slicer to filter. It's not so much about changing the design of a PivotTable, rather the filters that are applied to the PivotTable.

I hope that clarifies things, but please come back if anything isn't clear.

Kind regards,

Mynda

Hi Mynda

Thanks.  I need to practice.  Will come back to you if any further query on this one.

Regards

Dieneba

Mynda

I went back over it and still did not get it, sorry.  

The PivotTable Connections dialog enables you to specify which PivotTables you want that Slicer to filter.  I assumed the slicer applied to one specific PivotTables.  Can you give me a specific example of the purpose of using it?  Why would I create 2 PivotTable in one document?  I must be missing something.

Thanks for your help

Regards

Dieneba

Hi Dieneba,

Let's say you have a dashboard that has multiple Pivot Charts (connected to PivotTables) that display sales data for a group of departments. You might have a line chart displaying sales over time, a map chart showing sales by region, a bar chart showing sales by salesperson etc. You could add a slicer for the Department field and filter all of the Pivot Charts on the dashboard for a specific department or departments.

Does that help clarify the reason for connecting a single slicer to multiple PivotTables?

Kind regards,

Mynda

Hi Mynda

I sent you an example based on 3 different schools. When I choose the 3 school segments for each pivot table and choose for example Hyderabad it only update one pivot table. I do not understand this part at all.  It really is not clear.  What am I doing wrong?

Hi Dieneba,

For a Slicer to be able to filter multiple PivotTables, they must all use the same source data. If you have 3 separate sources, then you cannot connect the PivotTables to a single slicer for the School, unless you use Power Pivot, which isn't covered in the Excel Expert course.

Please share your Excel file so I can see the source of the PivotTables.

Mynda

Hi Mynda

The file is too big.  Here is the link from we transfer https://we.tl/t-MrjXL6gwAQ

Regards

Dieneba

Hi Dieneba,

Thanks for sharing your file. The good news is your PivotTables share the same dataset. The issue is that you haven't connected the Slicer for the city (you only need one to filter all PivotTables) to the PivotTables you want it to filter. Instead, you have a separate slicer for each PivotTable with each Slicer filtering a single PivotTable.

I cover setting up Slicers to filter multiple PivotTables at the 4:50 mark in tutorial 5.09 Slicers and Timelines. Perhaps you can watch this tutorial again and then come back if you're still stuck.

Mynda

Thanks Mynda

Will do.

Regards

Dieneba