---
schema_version: "1"
id: 84427f6334830668af37397fefe663e4b3e6821aedebcb39643e0f1e33348dd0
title: Data Visibility Considerations in Pivot and Compare 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_data_visibility.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widget_table_data_visibility.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 959b36feb343b42778e6a673f20ef3d4e5b3e423cd3afa2ab53ed048bd199935
description: Enabling features such as totals, subtotals, row totals, or column totals in pivot or compare tables can alter data display. These added summary rows expand the result set, which can cause certain values to be excluded if the query limit is too low.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Data Visibility Considerations in Pivot and Compare Tables

Enabling features such as totals, subtotals, row totals, or column totals in pivot or compare tables can alter data display. These added summary rows expand the result set, which can cause certain values to be excluded if the query limit is too low.

## Why This Happens

When row summaries are enabled in a table:

- The system generates additional rows or columns to show the summary information.
- These added rows count against the overall row limit.
- As a result, not all data rows are shown, especially in cases where the data has many unique values or groupings.

## Best Practice

For totals or subtotals to show all relevant data:

- Increase the query limit to accommodate both data and summary rows.
- If values seem to be missing in the pivoted dimension, review the current limit setting.
- Always consider how table configuration features can expand the result set beyond the initial limit.

#### 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.")