Forum

connect 2 or more t...
 
Notifications
Clear all

connect 2 or more tables with slicer

3 Posts
2 Users
0 Reactions
74 Views
(@redua-justin)
Posts: 22
Eminent Member
Topic starter
 

Hi All,

I'm using Excel 365 in windows and have some issue.

it's possible to connect 2 or more table using slicer ? it's not fit if changing all data to pivot due the visual it's quite not good or maybe there is another way that i don't know can share with me.

here the example file. how to make cell F3 changing follow the slicer depend on the month selected? the PORD data pick up from "sheet 1"

 

Thank you,

Justin R

 
Posted : 26/04/2022 7:04 am
(@mynda)
Posts: 4761
Member Admin
 

Hi Justin,

Slicers can only control a single table. If you want to control multiple reports, then you can create PivotTables from your Table source data and then connect PivotTable Slicer to multiple PivotTables. Note: Slicers can only control multiple PivotTables where those PivotTables reference the same source data. If you have separate data sources, then you'd need to use Power Pivot.

More on Slicers for PivotTables here.

Mynda

 
Posted : 26/04/2022 10:42 pm
(@redua-justin)
Posts: 22
Eminent Member
Topic starter
 

Hi Mynda,

Thank you for your explaining. it's done now.

Warm Regard,

Justin R

 
Posted : 11/06/2022 4:34 am
Share: