Help with calculation

[Anonymous]

Hi i am using a pivot table in Qlik Sense and have a table like below:

	Total	0	1	2	3	4	5
Total	1577	495	201	228	132	214	307
A	254	10	12	32	87	56	57
B	332	20	123	34	34	45	76
C	303	133	42	45	4	45	34
D	221	12	12	83	5	34	75
E	467	320	12	34	2	34	65

The numbers are unit sales

The Letter are areas

I want it to look like this with the % calculation:

	Totals		0		1		2		3		4		5
Total	1577	100%	495	31%	201	13%	228	14%	132	8%	214	14%	307	19%
A	254	16%	10	1%	12	1%	32	2%	87	6%	56	4%	57	4%
B	332	21%	20	1%	123	8%	34	2%	34	2%	45	3%	76	5%
C	303	19%	133	8%	42	3%	45	3%	4	0%	45	3%	34	2%
D	221	14%	12	1%	12	1%	83	5%	5	0%	34	2%	75	5%
E	467	30%	320	20%	12	1%	34	2%	2	0%	34	2%	65	4%

What is the measure i need to write to divide the units by the total?

[Anonymous · Accepted solution]

i have worked it out. Answer is =Sum(Sold)/Sum(Total Sold)