RickSchultz
New Member
- Joined
- Sep 12, 2008
- Messages
- 19
Hi! I've created my first PowerPivot workbook. I created 11 tables from a single MySQL database, and linked them based on primary/foreign key pairs.
I created a Pivot Table from the results, and dragged two columns into the row section; one from the "main" data table, and the other from a linked table.
The relationship between the two tables is one-many (from the linked table, basically a lookup table, to the main table). For each primary key in the main table, I should see one value from the linked table.
Instead, for each primary key on the main table, the Pivot Table returned ALL the values in the lookup table; it was as if there was no specified link.
Clearly, I've done something wrong with my linking. I've reviewed a few sites to look at normal linking practices, and as far as I can see, I've not done anything wrong. Can someone help me see what I've missed?
Thanks very much!
I created a Pivot Table from the results, and dragged two columns into the row section; one from the "main" data table, and the other from a linked table.
The relationship between the two tables is one-many (from the linked table, basically a lookup table, to the main table). For each primary key in the main table, I should see one value from the linked table.
Instead, for each primary key on the main table, the Pivot Table returned ALL the values in the lookup table; it was as if there was no specified link.
Excel 2010 | |||
---|---|---|---|
A | |||
1 | Row Labels | ||
2 | 27 | ||
3 | Brent Leung | ||
4 | Briana McIvor | ||
5 | Chester Grant | ||
6 | Christopher Lacroix | ||
7 | Dean Ara | ||
8 | Delete Me | ||
9 | Doneen Swart | ||
10 | Elaine McKay | ||
11 | Gosia Kamela | ||
12 | Greg Crompton | ||
13 | hello mister2 | ||
14 | Jay Brown | ||
15 | Jonny Producer | ||
16 | Karen Wrafter | ||
17 | Kristin MacCary | ||
18 | Nik Green | ||
19 | Producer Producer | ||
20 | Research Intern | ||
21 | Reuben Bradley | ||
22 | Rick Mattar | ||
23 | Rob McKee | ||
24 | Shaun Richards | ||
25 | Stephanie Barr | ||
26 | Steve Wyatt | ||
27 | |||
Sheet1 |
Cell Formulas | ||
---|---|---|
Range | Formula | |
A1 | Row Labels | |
A2 | 27 | |
A3 | Brent Leung | |
A4 | Briana McIvor | |
A5 | Chester Grant | |
A6 | Christopher Lacroix |
Clearly, I've done something wrong with my linking. I've reviewed a few sites to look at normal linking practices, and as far as I can see, I've not done anything wrong. Can someone help me see what I've missed?
Thanks very much!