Data table - sum row columns

[anya.conti]

I’m not sure if it would help in your specific usecase, but we’ve used pivot tables (without actually pivoting on something) for more accurate totals. They do summaries by calculating the metric for the whole group instead of a straight sum of everything in the column (so percentages would be a percentage of the whole rather than the sum of percentages for each group). It should also avoid sums of numeric dimensions if they’re added in as rows instead of values.

Here’s a couple threads of feature suggestions we’ve made for data tables:

Column Totals: Data Table vs. Pivot Table

Hello! I’ve been experimenting with the Column Totals in Data Tables (sum and average) and in Pivot Tables. I would love to be able to use the Pivot Table style of totals on standard Data Tables. Column 1: revenue → Total is expected to be the sum Column 2: list price sold → Total is expected to be a sum Column 3: discount % → Total is expected to be 1 - (total revenue/total list price sold) We can’t always use Pivot Tables to get these types of responsive totals because we sometimes need ro…

Table Chart Column Totals - Deduplication of Underlying Data

During our migration, we have found Pivot Table Column Totals and Data Table Sum Rows are evaluated differently on Holistics. This shows up especially where aggregated data model records are applicable to multiple selected dimensions in the table / pivot table. I understand improvements to Data Tables are in consideration and development. It may be beneficial to leverage a similar method for Sum Rows as is currently implemented in Pivot Table Column Totals. An example and details below: For…