Nicki has attended:
Excel Dashboards for Business Intelligence course
Slicers
Good Afternoon
I have two data sheets and have created pivot tables from these. I want to have only one slicer for the date field (month) but cannot link into the pivots from both sets of data. I have tried creating two tables on one sheet but cannot created a relationship between these two!
Is this even possible using Excel 2010 and no powerpivot add in?
many thanks
RE: Slicers
Hi Nicki,
Thank you for the forum question.
Slicers can filter any number of PivotTables but only if the PivotTables are created from the same source.
If your two tables are related data you can create relationships from MS Query from Get External Data from Other Sources on the Data tab.
You can also merge the two tables by using Power Query which are a free add-in you can download from Microsoft's website.
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
RE: Slicers
Thanks Jens. Our work systems dont allow downloads, so is there a way to do either of these with Excel 2010 and no add-ons?
RE: Slicers
Hi Nicki,
Yes you can create relationships from MS Query from Get External Data from Other Sources on the Data tab, but only if the tables are related tables (One to Many or One to One relationship).
If the tables are related you can also use a Vlookup to merge the two tables. One column in one of the tables must be related to one column in the second table. At least one of the related columns must only content unique values (the primary key).
Kind regards
Jens Bonde
Microsoft Office Specialist Trainer
Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us
London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector
