Question
PivotTable: calculate % of column total
+2Hi all,
Were trying to create a PivotTable where the cells show the numbers in a % of the column total.
Roughly something like this:
Category 1
Category 2
Category 3
2018
75%
50%
5%
2019
20%
30%
15%
2020
5%
20%
80%
However, were uncertain how we can calculate a total per category to use for the % calculation.
All ideas or tips are welcome!
Hi joosbuijs,
Thanks for reaching out. I am afraid that this is currently not possible. While
COUNT_TABLE(CASE_TABLE)/GLOBAL(COUNT_TABLE(CASE_TABLE))
allows to calculate the %age with all cases as denominator, this cannot be limited and applied to specific columns.
If there is anything else we can help you with, please reach out any time.
Regards,
Data Science Team
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.