Pivot Table - Ability to add row and column percentage statistics

[Btibert3]

What's your use case?
If I am using the Pivot table widget to create a "crosstab", it would be nice if I could use use the Count aggregation but also define row and column percentages. We can already add additional aggregations, so this would simply extend that idea to also show the % of totals via row and column.

What's your proposed solution?
Add options for count tables to show the distributions.

Are there any alternative solutions?

A crosstab widget where counts are the core aggregation against two categorical entries.

[janezd]

This would make sense.

Just a note: implementation is not entirely trivial. All current aggregations can be computed from the data in a cell (called here, they get the data prepared here. One way to implement row and column percentages would be to modify sub_table_getter to return the number of instances in the row and in the column (sums of masks that it constructs for selecting the data) and these would be passed to aggregation functions as additional arguments, but just for functions that require them (showing this either by a flag or by signature).