You are here:
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.
Did this article solve your issue?
Let us know so we can improve!
