pivot

[tyagishaila]

I have my pivot table in this form

 

But I need it in this form

Loyality	NoLoyality	Total	Loyality	NoLoyality	Total
Perc	Perc	Sale	Perc	Perc	Sale
40%	60%	558,588	42%	58%	603,816
44%	56%	145,166	45%	55%	165,081
50%	50%	38,166	50%	50%	51,720
53%	47%	11,986	53%	47%	14,053

Total comes using show partial sum, but it shows in % as Perc is in %, but I want it in numbers.

Plz solve this problem

Thanking You

[SunilChauhan]

what is the problem here.

[tyagishaila]

Sorry I think by mistake information is deleted.

[tyagishaila]

My required table form is

Loyality	NoLoyality	Total	Loyality	NoLoyality	Total
perc	perc	Sale	Perc	Perc	Sale
40%	60%	558,588	42%	58%	603,816
44%	56%	145,166	45%	55%	165,081
50%	50%	38,166	50%	50%	51,720
53%	47%	11,986	53%	47%	14,053

If I am using partial sum then total comes in % but my need is in numbers