Hi,
Please help me how can below represention be achieved in a pivot table. Need to represent the Customer Count for two periods so that the movement of count between periods in Customer Category can be shown.
|
|
Period 2 ----> |
Period1 |
Customer Catgory
|
A |
B |
C |
D |
E |
F |
Total |
A |
279 |
- |
- |
- |
- |
- |
279 |
B |
23 |
1,339 |
- |
- |
- |
- |
1,362 |
C |
- |
182 |
2,567 |
- |
- |
- |
2,749 |
D |
- |
5 |
528 |
5,617 |
- |
- |
6,150 |
E |
- |
1 |
13 |
1,365 |
3,978 |
- |
5,357 |
F |
- |
- |
4 |
205 |
2,429 |
13,459 |
16,097 |
Total |
302 |
1,527 |
3,112 |
7,187 |
6,407 |
13,459 |
31,994 |
Regards,
Suhas