Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 
suhasarchak
Partner - Contributor III
Partner - Contributor III

How to represent in a pivot table

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

Labels (1)
0 Replies