Calculate % of Total

[jagjivvt]

see attached excel output from Qlik. i need to get to teh results that i have formulated in place of EE%

[#2]

You can do it as you did on the attachment

it's what you want, you just have to change the name of the fields

Week	Sector	=sum([No of EE])	sum([No of EE   Enroled Top 6 Pension Status])	=sum([No of EE   Enroled Top 6 Pension Status])/sum(TOTAL [No of EE])
		18784	15971	85%
17/03/2013	Sector 1	2463	2079	11%
17/03/2013	Sector 2	2360	2283	12%
17/03/2013	Sector 3	52	43	0%
17/03/2013	Sector 4	4472	3798	20%
17/03/2013	Sector 5	9305	7646	41%
17/03/2013	Sector 6	132	122	1%

[jagjivvt]

Hi i tried that but i am using count instead of sum as the number of employee is not a number.

[jagjivvt · Accepted solution]

i managed to sort this by creating summary totals in script and use these in the expressions. thanks for all you responses