---
schema_version: "1"
id: 5152cb2694af8889b63ca6b1fb640a968365b63f0e84c8215f4a5aaa7fbc79af
title: Pivot Tables in Marketing Cloud Intelligence
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_anlyz_pivot.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_pivot.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: ebb63d6d852b61d8c9268f4255efdaddcd981dd127f3b10a0b316a86d6a61a55
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 Marketing Cloud Intelligence

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 is to validate your data and ensure that it’s loading correctly from the source 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.

- **[Create a Pivot Table from Scratch](https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_pivot_create.htm&release=264.0.0&type=5)**  
    Use a pivot table to explore and extract data.
- **[Create a Pivot Table Using a Data Stream](https://help.salesforce.com/s/articleView?id=mktg.dato_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.
- **[Manage Pivot Tables](https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_pivot_manage.htm&release=264.0.0&type=5)**  
    Edit, duplicate, and delete pivot tables in Marketing Cloud Intelligence.