---
schema_version: "1"
id: 4024f91c9e7a366de22e716fa30a5f065042ceee87bd86d1931e316a0422f502
title: Manage Pivot Tables 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_manage_pivot_tables.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_manage_pivot_tables.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 2f6a3903749ccbcea95661f356b14fe49b1ef1a066d3ff9f4d3e61f056d94bfa
description: You can manage pivot tables in Intelligence Reports for Engagement after you create them. You can edit, duplicate, and delete existing pivot tables.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Manage Pivot Tables in Intelligence Reports

You can manage pivot tables in Intelligence Reports for Engagement after you create them. You can edit, duplicate, and delete existing pivot tables.

### 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="d49882e57">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d49882e57 ">To create or export pivot tables</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d49882e57 ">Access, View &amp; Export / Schedule / Create &amp; Edit</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d49882e57 ">To save, edit and delete pivot tables </td>

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

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

The pivot tables list contains the following information:

 
| Column | Description |
| --- | --- |
| ID | The ID of the pivot table. This ID is generated automatically. |
| Name | The name of the pivot table. |
| Created By | The name of the user who created the pivot table. |
| Created On | The date and time the pivot table was created. |
| Last Update By | The user who made the last update. |
| Last Update On | The date and time the last update was made to the pivot table. |

From here, you can perform the following actions:

- **Edit** — If you want to change a pivot table, for example, change the [dimensions and measurements](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_dimensions_and_measurements.htm&release=264.0.0&type=5 "Dimensions and measurements are included when viewing dashboards, pivot tables, and reports. Use categories to find the data that’s most relevant to you.").
- **Duplicate** — If you want to create a copy of a pivot table to change it.
- **Delete** — If you want to delete a pivot table.
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mc_data_management_and_analytics-264-0-0-production-enus/7988f60d-cd94-4b42-8836-dc11773564b5/images/icon_note.png)
    
    Note When you delete a pivot table, it goes to your workspace bin. If for some reason you want to restore a pivot table, contact support.

#### See Also

- [Create a Flat Table Report](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_create_a_flat_table_report.htm&release=264.0.0&type=5 "You can create a flat table report when you want a report that extracts your raw data into a CSV or Excel file.")
- [User Roles and Permissions in Intelligence Reports](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_user_roles_and_permissions.htm&release=264.0.0&type=5 "To use Intelligence Reports for Engagement, your account must be assigned the Intelligence Reports for Engagement user role. The user role has the following permissions: Access, View and Export, Schedule, and Create and Edit.")