relative percentage

[nizamsha]

Hi all

I HAVE THE  following pivort table

property	brand	displaycount	stkqty	variance
fridge		20	25	125%
	samsung		05	25%
	LG		10	50%
	WHIRLPOOL		10	50%

how we r calculating the variance is stkqty/displaycount

this is a pivort table i have branchcode column after the brand column but branch code is excluded by displaycount ..how to calculate the the value

[#2]

(sum(stkqty) / sum(total displaycount))*100

or try this

(sum(stkqty)/ sum(displaycount))*100

or try this

(column(2)/column(1))*100

or in number tab --> select percent

[nizamsha]

I tried but its not coming it s coming like this

[#4]

try this

num((stkqty/sum(total displaycount)),'##00%')

see attachement

[#5]

Expression tab

Sum(stkqty)/Sum(displaycount)

and

Number tab -- select percent