How to represent in a pivot table

[suhasarchak]

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