chintugudda
New Member
- Joined
- Feb 23, 2019
- Messages
- 2
Hi
Below is the excel file. I am looking to get a pivot or summarize the result. The sales data is by month and region. Salespersons are identified in a mapping table. Trying to find an easy way to summarize. In real life example, regions are not 4 but variable is 100s. So dont want to use manual formulas. Any ideas?
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>
Below is the excel file. I am looking to get a pivot or summarize the result. The sales data is by month and region. Salespersons are identified in a mapping table. Trying to find an easy way to summarize. In real life example, regions are not 4 but variable is 100s. So dont want to use manual formulas. Any ideas?
A | B | C | D | E | F | G | H | I | |
1 | |||||||||
2 | Region | Jan | Feb | Total | Jan-Sales Person | Feb-Salesperson | |||
3 | East | 100 | 120 | 220 | Rick | Rick 50% Boss 50% | |||
4 | West | 202 | 200 | 402 | Tom | John | |||
5 | North | 56 | 60 | 116 | John | Boss | |||
6 | South | 150 | 170 | 320 | Boss | Jeb | |||
7 | 508 | 550 | 1058 | ||||||
8 | DESIRED OUTPUT | ||||||||
9 | Rick | Tom | John | Boss | Jeb | Total | |||
10 | East | 160 | 160 | ||||||
11 | West | 202 | 202 | ||||||
12 | North | 256 | 256 | ||||||
13 | South | 270 | 170 | 440 | |||||
14 | 160 | 202 | 256 | 270 | 170 | 1058 | |||
15 | |||||||||
16 |
<colgroup><col width="64" span="10" style="width:48pt"> </colgroup><tbody>
</tbody>