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!
