How to create a pivot table in similar format below?

[posywang]

Hi,

I was provided with a pivot table in Excel below to create one similar to it in Qlikview. I am able to do it without percentage column. Do you know if it is possible to add percentage? Thanks.

State	City	A	B	C	D	Total	Percentage
New York	Queens	3	0	0	0	3	4%
New York	Brooklyn	1	0	0	0	1	1%
New York	Manhanttan	0	0	8	20	28	35%
	Subtotal	4	0	8	20	32	40%
Connecticut	Hartford	10	5	1	25	41	51%
Connecticut	New Haven	1	5	0	1	7	9%
	Subtotal	11	10	1	26	48	60%
	Total	15	10	9	46	80	100%
	Percent of total	18.8%	12.5%	11.3%	57.5%
	Percent of New York	12.5%	0.0%	25.0%	62.5%

[vinieme12]

try the approach I used in this post

Partial Sums in straight table | Custom Labels in Pivot SubTotals