Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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.
Try this
Count(val)/Count(TOTAL val)
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.
Sure, sounds like a great idea