---
schema_version: "1"
id: 122ea89adc031427a5df8b2af0e2c14b82a65d451692d8dc28b60211a7bac106
title: Pivot Tables Overview
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_dat_pivot_tables_overview.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_dat_pivot_tables_overview.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: fe549383e289e60140e0eb8572da964524c44b081273cdda414341c5ca69aa4f
description: Pivot tables allow you to explore your data from multiple perspectives. You can calculate, summarize, and analyze data by seeing comparisons, patterns, and trends in your data. With pivot tables, you can create custom reports without the need for query formulas, such as SQL queries.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Pivot Tables Overview

Pivot tables allow you to explore your data from multiple perspectives. You can calculate, summarize, and analyze data by seeing comparisons, patterns, and trends in your data. With pivot tables, you can create custom reports without the need for query formulas, such as SQL queries.

### 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>

For a detailed explanation of the metrics featured in pivot tables, see [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.").

For more information about pivot tables, click these links:

![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 Emails configured to Suppress from Send Reports aren't included in Intelligence Reports.

- **[Out-of-the-Box Pivot Table Examples](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_pivot_table_use_cases.htm&release=264.0.0&type=5)**  
    By default, Intelligence Reports for Engagement comes with five out-of-the-box pivot table examples. These examples help you get started so you can see how the most common pivot tables are configured and set up. You can use them as is, copy and then adjust them, or even delete them if they‘re not required.
- **[Create a Pivot Table in Intelligence Reports](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_create_a_pivot_table.htm&release=264.0.0&type=5)**  
    Use a pivot table to explore and extract data. For example, you can get sends and open rates for all your emails to see how well a specific email performed. You can also export a pivot table locally or use it to create a scheduled report.
- **[Customize a Pivot Table in Intelligence Reports](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_customize_a_pivot_table.htm&release=264.0.0&type=5)**  
    You can change the data that is displayed in a pivot table, show or hide columns, and make other customizations.
- **[Export a Pivot Table in Intelligence Reports](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_export_a_pivot_table.htm&release=264.0.0&type=5)**  
    You can export a pivot table as a report and run it as part of a workflow in real time or on a defined schedule. You can also export to an Excel file, for example, and share it with others.
- **[Manage Pivot Tables in Intelligence Reports](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_manage_pivot_tables.htm&release=264.0.0&type=5)**  
    You can manage pivot tables in Intelligence Reports for Engagement after you create them. You can edit, duplicate, and delete existing pivot tables.
- **[Apply Filters to a Pivot Table](https://help.salesforce.com/s/articleView?id=mktg.mc_dat_pivot_table_filter.htm&release=264.0.0&type=5)**  
    Add filters to a pivot table to narrow down the data and focus on what’s relevant to your use case. For example, add a filter to focus on a specific email name instead of all the emails in the campaign. Or filter by a campaign name to focus on that campaign.