---
schema_version: "1"
id: 2d631de786c4aa45f1d2037ed80543e06cf2902cdb1d1fb761102753d9321c1a
title: Explore Pivot Tables with Expand and Collapse
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/release-notes/260-0-0/rn_bi_dashboard_expand_collapse_pivot.md
canonical_url: https://help.salesforce.com/s/articleView?id=release-notes.rn_bi_dashboard_expand_collapse_pivot.htm&release=260&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 26864abff370d312ddbff01201f15a9081fdd9bf8b965d9436d49fb2a914fce0
description: You can now expand and collapse groups and sub-groups in pivot tables to help you focus on specific insights and customize your view of large datasets.
products:
  - Cross Cloud Packages Solutions
release: "260"
---
# Explore Pivot Tables with Expand and Collapse

You can now expand and collapse groups and sub-groups in pivot tables to help you focus on specific insights and customize your view of large datasets.

**Where:** This change applies to CRM Analytics in Lightning Experience and Salesforce Classic. CRM Analytics is available in Developer Edition and for an extra cost in Enterprise, Performance, and Unlimited editions.

**How:** Create or edit a pivot table on your dashboard. Click the Formatting icon and expand the Layout section. Click **Enable Expand or Collapse**.

![Enable Expand or Collapse setting.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-salesforce_release_notes-260-0-0-production-enus/ba62a63b-6cd1-440e-8d24-e867afab0363/salesforce_release_notes/images/analytics/rn_bi_dashboard_expand_collapse_pivot.png)

#### See Also

- [_Salesforce Help_: Organize and Summarize Data in a Pivot Table](https://help.salesforce.com/s/articleView?id=analytics.bi_explorer_pivot_table.htm&language=en_US)