---
schema_version: "1"
id: 041da5c010e1f1409d2d66a7614bc5a4dbbf01b715e38f6e835027a38d391043
title: Create a Pivot Table in Marketing Intelligence
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mc_mi_pivot_tables_create.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mc_mi_pivot_tables_create.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 799bf85ebc2a0f56b25baef14759d1c0a61e93379d7f8e7907a838f9ff6dc020
description: Verify that pipeline data is mapped and processed correctly before you use it in dashboards and other analyses.
products:
  - Marketing
  - Marketing Cloud Intelligence
  - Marketing Cloud Next
release: "264"
---
# Create a Pivot Table in Marketing Intelligence

Verify that pipeline data is mapped and processed correctly before you use it in dashboards and other analyses.

### Required Editions

<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:left;vertical-align:top;" id="d5967e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d5967e38 ">To create, edit, and delete reports in private folders:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d5967e38 ">Marketing Intelligence Data Specialists or Admin</td>

          </tr>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d5967e38 ">To create, edit, and delete reports in public and private folders:</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d5967e38 ">Report Builder (Lightning Experience) in Data 360</td>

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

1. In Marketing Intelligence, select Data Management, and then select Data Pipelines.
2. From the data pipeline you want to analyze, expand the actions menu, and select Pivot Table.
    
    Marketing Intelligence opens a report in Salesforce Report Builder. The report is prefiltered for the selected pipeline and includes the default dimensions and measurements for that pipeline type.
3. To change how the data is organized, add, remove, or reorder fields under Group Rows.
4. Under Columns, review the selected measurements and add or remove measurements as needed. Available measurements depend on the data pipeline.
5. To narrow the results, add an aggregate filter.
6. To visualize the results, click **Add Chart**, select a chart type, and configure its value and grouping.
7. Set whether the report shows subtotals and the grand total.
8. Click **Run** to review the complete report.
9. Click **Save** or **Save & Run**, enter the report details, and select a report folder.
    
    The saved pivot table is available from Marketing Intelligence on the Reports tab.

To examine a group, select a chart value, or open the grouped result and apply a drill-down grouping.

To work with the results outside Salesforce, export the report as a CSV or Excel file. Data 360 report display and export limits apply.