---
schema_version: "1"
id: ac2732eff37571afb09183f5c139115511ddedcce86fb3b79c8283c337a5192c
title: Pivot Table Functional Constraints and Technical Requirements
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_dashboard_widget_pivot_constraint.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widget_pivot_constraint.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 8f94104c4315c7449b271f1e10e027203ec11dcd5be95bab11f2a7c049852542
description: While pivot tables are essential for summarizing data, their performance and display are subject to specific technical constraints and configuration requirements. The information in the table defines the availability of certain calculation features and the behavior of interactive elements. Understanding these established boundaries makes sure that the resulting pivot tables remain accurate and functional.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Pivot Table Functional Constraints and Technical Requirements

While pivot tables are essential for summarizing data, their performance and display are subject to specific technical constraints and configuration requirements. The information in the table defines the availability of certain calculation features and the behavior of interactive elements. Understanding these established boundaries makes sure that the resulting pivot tables remain accurate and functional.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
      <colgroup>
        <col style="width:50%">
        <col style="width:50%">
      </colgroup>
      <thead class="slds-text-title_caps ">
        <tr class="">
          <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d35084e34">Category</th>
          <th scope="col" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" id="d35084e37">Details</th>
        </tr>
      </thead>
      <tbody>
        <tr class="">
          <td data-label="Category" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d35084e34 ">Totals &amp; Subtotals</td>

          <td data-label="Details" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d35084e37 ">
            <ul>
              <li>Subtotals and totals only appear if you pivot on a field other than the compound
                date. They're incompatible with Compact Form 1.0 in time zone-enabled orgs.</li>

              <li>Subtotals function when sorting within groups but fail when sorting across
                groups.</li>

              <li>Row totals are unavailable if the underlying query uses an aggregate filter or
                window function formula.</li>

              <li>Query limits can restrict column total accuracy whenever the record count
                exceeds the specified limit.</li>

              <li>Subtotals and totals don't function properly in CRM Analytics Direct Data.</li>

            </ul>
          </td>

        </tr>
        <tr class="">
          <td data-label="Category" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d35084e34 ">Expand and Collapse Explorer Mode Behavior</td>

          <td data-label="Details" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d35084e37 ">
            <ul>
              <li>Position a hidden column before a pivoted column to preserve the pivot
                structure.</li>

              <li>Expand and collapse interactions permanently change the subtotal query.</li>

              <li>Hiding or showing dimensions in Explorer Mode can result in inaccurate subtotals
                due to Explorer Mode's flexibility. Re-enabling subtotals fails if columns remain
                hidden, as expand and collapse requires full visibility.</li>

            </ul>
          </td>

        </tr>
        <tr class="">
          <td data-label="Category" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d35084e34 ">Expand and Collapse Preview Mode Behavior</td>

          <td data-label="Details" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d35084e37 ">
            <ul>
              <li>Refreshing the page resets all expand and collapse interactions.</li>

              <li>When "Enable Expand or Collapse" is on, the pivoted column remains pivoted while
                in preview.</li>

            </ul>
          </td>

        </tr>
        <tr class="">
          <td data-label="Category" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d35084e34 ">Expand and Collapse Limitations</td>

          <td data-label="Details" class="slds-cell-wrap" style="text-align:left;vertical-align:top;" headers="d35084e37 ">
            <ul>
              <li>
                <p>Expand and collapse is available for CRM Analytics datasets and isn’t
                  compatible with other data sources.</p>
              </li>

              <li>
                <p>Requires queries built in Compact Form 2.0 with datasets as the data
                  source.</p>
              </li>

              <li>
                <p>Turn on Enable Subtotals for the feature to function.</p>
              </li>

              <li>
                <p>Incompatible with queries that use data blending or semi-anti joins, as
                  subtotals don't operate accurately in these modes.</p>
              </li>

              <li>Expand and collapse don't function properly when measures or dimensions change
                through dynamic projections or interactions.</li>

              <li>
                <p>When a collapsed date group expands, it deconstructs into individual date
                  parts, such as a Year+Month group expanding into separate Year and Month.</p>
              </li>

            </ul>
          </td>

        </tr>
      </tbody>
    </table>

#### See Also

- [Data Visibility Considerations in Pivot and Compare Tables](https://help.salesforce.com/s/articleView?id=analytics.bi_dashboard_widget_table_data_visibility.htm&language=en_US)