% calculation

[upaliwije]

I have following Pivot table in my data model. I want calculate the % (highlighted in  red). Pls help me

		GROSS_PREMIUM
	BUSINESS_TYPE	NEW_BUSI.		RENEWALS
DEPT	BUSINESS_SOURCES		%		%
HEAD	A	7,855,432	18%	11,920,417	22%
HEAD	B	2,559,225	6%	3,450,250	6%
HEAD	C	2,251,519	5%	1,744,495	3%
HEAD	D	29,875,702	70%	37,314,178	69%
HEAD	Total	42,541,878	100%	54,429,339	100%
CITY	A	10,018,210	12%	13,816,521	15%
CITY	B	3,760,713	5%	9,376,752	10%
CITY	C	1,084,472	1%	444,017	0%
CITY	D	68,240,497	82%	68,232,060	74%
CITY	Total	83,103,892	100%	91,869,351	100%

My present set expression is as follows

SUM({$<POL_TYPE={'N','R','A'}>}PREMIUM)

[maxgro]

SUM({$<POL_TYPE={'N','R','A'}>}PREMIUM)

/

SUM({$<POL_TYPE={'N','R','A'}>} total <DEPT> PREMIUM)

[upaliwije]

That is not working

[petter · Accepted solution]

Sum( {$<POL_TYPE={'N','R','A'}>} PREMIUM) / Sum( {$<POL_TYPE={'N','R','A'}>} TOTAL <DEPT,BUSINESS_TYPE> PREMIUM)