Hi,
I have a data table that has 3 columns: -, 0, 1
How do I go about calculating the total percentage for each column?
I would potentially want a KPI in my dashboard that immediately tells me
thanks,
Terence
Hi Terence!
When you write "the total percentage for each column", what do you mean exactly?
Is 100% the sum of all values in all columns?
Is that what you are looking for:
X | Y | Z
-------
1 | 5 | 4
2 | 7 | 8
6 | 0 | 3
-------- (Total: 36)
25% | 33% | 42%
Hi Terence!
When you write "the total percentage for each column", what do you mean exactly?
Is 100% the sum of all values in all columns?
Is that what you are looking for:
X | Y | Z
-------
1 | 5 | 4
2 | 7 | 8
6 | 0 | 3
-------- (Total: 36)
25% | 33% | 42%
Yes, that's essentially what I would want. Apologies if I didn't make it clear.
If I could get something similar to the example you provided, that would be great.
For x it would be:
SUM("Table"."Column_X") /
(SUM("Table"."Column_X") + SUM("Table"."Column_Y") + SUM("Table"."Column_Z"))
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
