I am new to PowerPivot and require some help in consolidating 2 tables.
I've imported the data in PowerPivot and created a relationship between the "INV" field in both tables:
Table 1
<tbody>
</tbody>
Table 2
<tbody>
</tbody>
Current Outcome
<tbody>
</tbody>
Desired Outcome
<tbody>
</tbody>
Unfortunately when i run my pivot table i don't get the desired result. What should i change to correct my table to get the desired outcome?
Thanks for your help!
Chris
I've imported the data in PowerPivot and created a relationship between the "INV" field in both tables:
Table 1
INV | Name |
INV0001 | Apple |
INV0002 | Orange |
INV0003 | Grape |
INV0004 | Pineapple |
INV0005 | Banana |
<tbody>
</tbody>
Table 2
INV | IO |
INV0001 | a |
INV0001 | b |
INV0001 | c |
INV0001 | d |
INV0002 | e |
INV0003 | f |
INV0004 | g |
INV0005 | h |
<tbody>
</tbody>
Current Outcome
Name | IO |
Apple | a |
Apple | b |
Apple | c |
Apple | d |
Apple | e |
Apple | f |
Apple | g |
Apple | h |
Banana | a |
Banana | b |
Banana | c |
Banana | d |
Banana | e |
Banana | f |
Banana | g |
Banana | h |
<tbody>
</tbody>
Desired Outcome
Name | IO |
Apple | a |
b | |
c | |
d | |
Orange | e |
Grape | f |
Pineapple | g |
Banana | h |
<tbody>
</tbody>
Unfortunately when i run my pivot table i don't get the desired result. What should i change to correct my table to get the desired outcome?
Thanks for your help!
Chris