Register
Log In
Unanswered
Home
New Member
Dashboards
Power Query
Power Pivot
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: 57
Currently Online: Max Neumann
18 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
SunnyKow: 651
Frans Visser: 210
David_Ng: 96
mey tithveasna: 71
A.Maurizio: 60
rathanak: 58
yhooithin05: 54
Anders Sehlstedt: 47
julian: 46
PaulFogel: 37
Newest Members:
Ajay Mukhi
Stephen Motte
Rodney Hoyle
michael pitre
Samantha Burleson
Krishnaa Kurugod
David McSwain
Shameem Nassiree
Alanna Henderson
Janel Oz
Forum Stats:
Groups: 2
Forums: 18
Topics: 935
Posts: 4405
Member Stats:
Guest Posters: 1
Members: 42350
Moderators: 1
Admins: 3
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas
