Percentage of dimension in a table

[#1]

Hello everyone,

Im trying to compute in qlikview the % of dimension 1 as i show in the last column below.

In my data i have lots of fields in dimension 1, in this example i only use numbers 1 and 2.

Can anyone help me finding a formula that calculates how many cases exists from dimension 2 in the total of dimension 1.

Ex: Dimension 1 = 1

Dimension 2 = A, B, C, D

I want to compute the percentage of A in the total dimension 1 =1 , the percentage of B in the total of dimension 1=1.

Dimension1	Dimension 2	Count values	%	% of Dimension 1
1	A	10	7%	14%
1	B	20	14%	29%
1	C	30	21%	43%
1	D	10	7%	14%
2	A	10	7%	14%
2	B	20	14%	29%
2	C	30	21%	43%
2	D	10	7%	14%

Best regards,

Eliano Marques

[#2]

Hi, try this:

count(distinct Value)/ count(total <Dimension1> distinct Value)

Regards