February 24, 2016
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
July 16, 2010
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.
Most Users Ever Online: 107
Currently Online: Philip Treacy, Ironcladrooster, Alan Sidman
Currently Browsing this Page:
Frans Visser: 263
Anders Sehlstedt: 149
mey tithveasna: 71
Anne Walsh: 68
MITUL PARIKH: 68
Mohamed Saliha: 59
Guest Posters: 2
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas