---
schema_version: "1"
id: 18bab3bd30bb5df118c6a0ff11a64aba35cb63ed7c2a5b6590466e8b5d76343e
title: Pivot Tables in Salesforce MDP
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_anlyz_pivot.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_anlyz_pivot.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: b2308aaba001917aa3b071872e70c585e627cbb4157a2a6cb27568644c4cde2d
description: Explore your data from multiple perspectives using pivot tables. You can calculate, summarize, and analyze data by seeing comparisons, patterns, and trends in your data. You can also create custom reports without using query formulas, such as SQL queries.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Pivot Tables in Salesforce MDP

Explore your data from multiple perspectives using pivot tables. You can calculate, summarize, and analyze data by seeing comparisons, patterns, and trends in your data. You can also create custom reports without using query formulas, such as SQL queries.

A common use case for using pivot tables in Marketing Cloud Intelligence Data Pipelines is to validate your data and ensure that it’s loading correctly from the source into MDP and that the values are aggregating correctly. After you create a pivot table, you can export it locally or turn it into a scheduled report.

- **[MDP Create a Pivot Table from Scratch](https://help.salesforce.com/s/articleView?id=mktg.mcidp_anlyz_pivot_create.htm&release=264.0.0&type=5)**  
    Use a pivot table to explore and extract data.
- **[MDP Create a Pivot Table Using a Data Stream](https://help.salesforce.com/s/articleView?id=mktg.mcidp_anlyz_pivot_stream.htm&release=264.0.0&type=5)**  
    Create a pivot table using a data stream to base it on already-defined measurements and dimensions.
- **[MDP Manage Pivot Tables](https://help.salesforce.com/s/articleView?id=mktg.mcidp_anlyz_pivot_manage.htm&release=264.0.0&type=5)**  
    Edit, duplicate, and delete pivot tables in Marketing Cloud Intelligence Data Pipelines.