Dividing a column by the column total

[Anonymous]

Hi,

Can someone please tell me the expression for Col 3?

Col 1	Col 2	Col 3
Name	count(val)	count(val)/Total(count(val))
A	2	2/14 = 0.14
B	3	3/14 = 0.21
C	5	5/14 = 0.35
D	4	4/14 = 0.28
TOTAL	14

Thanks

[sunny_talwar]

Try this

Count(val)/Count(TOTAL val)

[OmarBenSalem · Accepted solution]

I'd say count(val)/count({<Name=>}total val), with that, even he filter with a name, he'll always get the correct value for the pourcentage in column 3.

If he doesn't do so, he'll get 100% when he select Name=A for example.

[sunny_talwar]

Sure, sounds like a great idea