Register
Log In
Unanswered
Home
New Member
February 24, 2016
Offline
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
Offline
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
Most Users Ever Online: 107
Currently Online: Philip Treacy, Ironcladrooster, Alan Sidman
2 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 906
Frans Visser: 263
Anders Sehlstedt: 149
David_Ng: 122
A.Maurizio: 76
mey tithveasna: 71
Anne Walsh: 68
MITUL PARIKH: 68
julian: 60
Mohamed Saliha: 59
Newest Members:
Larry Clemons
Mark Enriquez
sri ram
Tammy Colglazier
Barbara Jansen
Julie Manross
nuel kpa
Mellisa Tanksley
Danny Falk
Cindy Collins
Forum Stats:
Groups: 2
Forums: 20
Topics: 1357
Posts: 6204
Member Stats:
Guest Posters: 2
Members: 46105
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
