Data table - sum row columns

[David_Carnley]

Hello,
I have a data table viz and using a sum row. But for some of the columns it doesn’t make sense… For example one of them is an invoice number. It’s an integer value, but it doesn’t make any sense to calculate a sum. Another is a percentage based on 2 other columns. An average of this column might make sense, but a sum sure does not.

Is there a way to exclude specific columns from the Sum Row feature?

[duc]

Hi David,

Thank you for reaching out to us.

To better understand your request and provide more accurate solutions, could you please add some screenshots and elaborate on the difficulties you’re facing more? We look forward to hearing from you.

[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…