To show sub total as 100% in pivot table

[Anonymous]

Hi,

I want to show the values in my pivot table as 100% for each sub total

I need to show my pivot table like below

Cg1	Cg2	Expr1	Expr2
	Total	100%	100%
xxx	aaa	25%	50%
	bbb	25%	30%
	ccc	50%	20%
	Total	100%	100%
yyy	ddd	10%	60%
	eee	70%	40%
	fff	20%	-
	Total	100%	100%
zzz	ggg	15%	90%
	hhh	75%	10%
	iii	10%	-

Now I can show the partial total by doing the settings on Presentation tab.

My concern is I am getting the overall total as 100% but not the each sections total as 100%. The 100% should be shown for all fields in the cyclic groups.

So What should I do to get 100% value in each section??

Can anyone help me in this??

Thanks in Advance

Regards,

Leni

[Anonymous]

Thanks a lot for your helps