PivotTable: calculate % of column total

Hi all,

We’re 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, we’re 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