How to create this pivot table ?

[#1]

I would like to convert table 1 to table 2 format :

Table 1 :

Customer	Curr Total	Prev Total	Delta Total	Curr Cr	Prev Cr	Delta Cr	Curr Dr	Prev Dr	Delta Dr
Cust 1	350	250	100	550	500	50	-200	-250	50
Cust 2	100	90	10	100	100	0	0	-10	10

Table 2 :

Customer		Current	Previous	Delta
Cust 1	Total	350	250	100
	Cr	550	500	50
	Dr	-200	-250	50
Cust 2	Total	100	90	10
	Cr	100	100	0
	Dr	0	-10	10

Thanks.

[MayilVahanan]

Hi

     Where Cr and Dr are field value?

     If so,

     Use like this,

     Customer and FieldName(which contain Cr,Dr) as Dimension

     Use expression as: =Current,Previos ,Delta as expression use setanalysis if FieldName(which contain Cr,Dr) also contain more value. like sum({<FieldName = {'Cr','Dr'}>}Sales)

And in presentation tab,select Sub total -> on Top for Customer and Dimension , for  FieldName(which contain Cr,Dr) set label as blank

Hope it helps