Hi, using Excel 2016 (pivot tables, power Query, power Pivot) is it possible to link, combine multiple tables on different subjects but related, as an example a table for 1)Sales 2)Backorders, 3)Orders that are scheduled to ship this month. Where each table contains multiple duplicate field types i.e. account details, product details, various dates, values (units, sales/backorder values) and also dissimilar fields?
The aim is to be able to use a single slicer for example to select an account name and all the tables(pivots) would change to show sales, backorders, scheduled to ship in summary and detail for that account
If so what are the general steps?
Thanks for any guidance
Hi Ian,
Yes, you should load all of your tables into Power Pivot. You'll need to add a dimension table that contains a unique value for the account name. You can then create relationships between this dimension table and your sales, backorders and orders tables.
When you build the PivotTable you use the Account Name field from your dimension table and the values fields from your other tables. Likewise, the Slicer should come from your dimension table.
Mynda
Pls show by an Example ..
