I have two tables, that I need to merge. One table includes the sales information per account, the second table includes the sales staff assigned to each account. Each table includes the account ID, which I am using to connect the two tables. Here is a brief example of the two tables:
<tbody>
</tbody>
<tbody>
</tbody>
What I would like the output to look like is:
Apple
This way, I can sort by sales (or the other various metrics I have on the account level) and immediately know which sales people to praise or provide "additional guidance" to.
The output I can currently getting is:
<tbody>
</tbody>
Any help in getting me to my desired output would be greatly appreciated.
Thank you,
Eli
Account ID | Name Of Account | Sales |
1 | Apple | $500 |
2 | $0 | |
3 | Microsoft | $200 |
<tbody>
</tbody>
Account ID | Sales Person Name |
1 | Jim |
1 | Jane |
2 | John |
3 | James |
3 | Janet |
3 | Joe |
<tbody>
</tbody>
What I would like the output to look like is:
Apple
Jim
Jane
GoogleJohn
MicrosoftJames
Janet
Joe
This way, I can sort by sales (or the other various metrics I have on the account level) and immediately know which sales people to praise or provide "additional guidance" to.
The output I can currently getting is:
Row Labels |
Apple |
James |
Jane |
Janet |
Jim |
Joe |
John |
James |
Jane |
Janet |
Jim |
Joe |
John |
Microsoft |
James |
Jane |
Janet |
Jim |
Joe |
John |
Grand Total |
<tbody>
</tbody>
Any help in getting me to my desired output would be greatly appreciated.
Thank you,
Eli