---
schema_version: "1"
id: a1ff2897f7a7799cd9bf93c6005d4a11ce27c33ea234a0f853c3165f7274279b
title: Subtotal Considerations for Tables
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_dashboard_widget_table_subtotal.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widget_table_subtotal.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 62b2acd639531387e7f2e015ef137a115debb396e134ec4d61106db5cbbd5bcd
description: The ability to expand and collapse rows, often seen in table widget types such as compare and pivot, depends on the presence and proper display of subtotals. This means that the ability to expand and collapse rows within these tables is closely linked to how subtotals are configured and rendered. And, if subtotals are turned off in a table widget, hiding the first row or column can make the entire table disappear.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Subtotal Considerations for Tables

The ability to expand and collapse rows, often seen in table widget types such as compare and pivot, depends on the presence and proper display of subtotals. This means that the ability to expand and collapse rows within these tables is closely linked to how subtotals are configured and rendered. And, if subtotals are turned off in a table widget, hiding the first row or column can make the entire table disappear.

## What Can Happen When Subtotals Are Disabled

If subtotals are turned off for any field within a table, a critical dependency for the table's internal grouping mechanism is removed. The presence and integrity of subtotals is integral to the visibility of individual rows. Without this basic data, the table won't work well if users expand or collapse rows. This can also cause problems with how the table looks, table organization, or the table is completely hidden.

## Expanding or Collapsing Rows and Subtotals

To avoid this issue, keep subtotals enabled for all dimensions to expand or collapse rows. If it’s necessary to turn off subtotals, avoid collapsing the first dimension.

#### See Also

- [Add a Table Widget to Show Record Details and Create Calculated Columns](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widgets_table_add_flex.htm&release=264.0.0&type=5 "You can add different types of tables to a CRM Analytics dashboard. To view record-level details, add a values table. A values table can show details like how long a case has been open and who owns it. To create custom columns in a table based on calculations from existing fields, add a compare table. If the underlying query contains at least one grouping, you can create a pivot table.")