---
schema_version: "1"
id: 2daae901ca5f56efaa65ce18fafbd003448d8e4d2c1befa1c9adda02103b0870
title: Customize a Pivot Table in Intelligence Reports
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_dat_customize_a_pivot_table.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_customize_a_pivot_table.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 32766cd37f99f37e162d66709a8022f4e3a204d856cc9ffc42d24d2ac72839aa
description: You can change the data that is displayed in a pivot table, show or hide columns, and make other customizations.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Customize a Pivot Table in Intelligence Reports

You can change the data that is displayed in a pivot table, show or hide columns, and make other customizations.

### Required Editions

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small edition"><colgroup><col></colgroup><tbody><tr class=""><td class="slds-cell-wrap" style="vertical-align:top;">Available in: Intelligence Reports and Intelligence Reports Advanced</td></tr></tbody></table>

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small permission">
        <colgroup>
          <col style="width:50%">
          <col style="width:50%">
        </colgroup>
        <thead class="slds-text-title_caps ">
          <tr class="">
            <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="text-align:center;vertical-align:top;" id="d8887e57">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d8887e57 ">To save, edit, and delete pivot tables</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d8887e57 ">Create &amp; Edit</td>

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

1. In Analytics Builder, select **Intelligence Reports**.
2. On the Pivots Tables tab, select the pivot table that you want to change and click **Edit**.
3. To hide a dimension or measurement, in the Pivot Table Settings window, hover over the field name and click the eye icon.
4. To delete a field, click **X**.
5. To add or change data, click the **\+** icon.
6. To hide the column or row totals in the pivot table, click **Options** next to **Columns** or **Rows** and deselect the checkbox.