---
schema_version: "1"
id: 95637450ef0132846ab6f463c59255b2c4a2ecd05b530673f2211fc0febf3910
title: Organize and Summarize Data in a Pivot Table
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_explorer_pivot_table.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_pivot_table.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 5f03cc661883a7c88199efc40159ee9300af27012c4b80b251bbd644a63081c3
description: To identify patterns in large amounts of data quickly, arrange the data by a key dimension in a pivot table. For deeper comparative analysis, you can group the pivoted data further and then add row and column totals, subtotals, and grand totals to the pivot table. To evaluate data in a pivot table based on ranking, sort a measure for a pivoted dimension in ascending or descending order (beta).
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Organize and Summarize Data in a Pivot Table

To identify patterns in large amounts of data quickly, arrange the data by a key dimension in a pivot table. For deeper comparative analysis, you can group the pivoted data further and then add row and column totals, subtotals, and grand totals to the pivot table. To evaluate data in a pivot table based on ranking, sort a measure for a pivoted dimension in ascending or descending order (beta).

You can add row totals, column totals, or both to pivot tables with at least two groupings in a lens or dashboard. When you select row and column totals, the pivot table also shows the row and column grand totals. To show subtotals and to sort by a measure, add at least two groupings in addition to the pivoted dimension.

For example, your pivot table shows sales data pivoted on region and grouped by product category and subcategories. To see total sales for each product category by region, click ![Totals button in pivot tables](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_totals_button.png) (1), and then select **Show Column Totals** (2). To see sales totals for each region across all product subcategories, select **Show Row Totals** (3). To see sales subtotals by product subcategory across all regions, select **Show Subtotals** (4).

![Row and column totals and subtotals in pivot tables](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_pivot_totals_subtotals.png)

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note When you edit the SAQL for a table in which you’ve shown subtotals, and you rename a column, the subtotals background becomes clear and the column title disappears.

To hide the subtotal for a subgroup that you’re not interested in, select **Hide Subtotals** from its context menu.

![Hide subtotals for a subgroup in pivot tables](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_pivot_subtotals_hide.png)

To identify the product subcategory with the highest sales for a region, sort its Sum of Sales column. Click ![Drop down button in column header](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/dropdown_icon.png) in the column header (1), and then select Sort Descending (2). To find the product subcategory under furniture with the highest sales for the region, click Sort Within Groups (Desc) (3).

![Pivot tables sort feature](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_pivottable_sort.jpg)

To expand and collapse groups and sub-groups in pivot tables, go to Formatting and select **Enable Expand or Collapse**.

![Row and column totals and subtotals in pivot tables](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/bi/images/bi/bi_explorer_expand_collapse_pivot.png)

## Pivot Table Limitations

Keep these limitations in mind when working with pivot tables.

- When using compact form 1.0, totals and subtotals aren't supported in time zone-enabled orgs.
- To view totals in a time zone-enabled org, pivot the table on a field other than the compound date.
- Subtotals are supported when sorting within groups but not when sorting across groups.
- Row totals aren’t supported when the underlying query has an aggregate filter or window function formula.
- For accurate column totals, ensure that query limits are high enough to include all the records you want in your analysis.
- Totals and subtotals aren't supported in CRM Analytics Direct Data.
- When fixed columns exceed the viewport width, data beyond the fixed columns becomes inaccessible. If you add more columns either through the dashboard or through JSON, the scroll bar doesn't appear and you can't scroll. To resolve this issue, reduce the number of fixed columns or resize columns to fit within the viewport.