---
schema_version: "1"
id: 3d2df0663a95d77c7b75c4f09ccbe472463e6ddb608ba922c9d060332f978dc2
title: MDP Create a Pivot Table from Scratch
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/mcidp_anlyz_pivot_create.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.mcidp_anlyz_pivot_create.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: a6185dc67cb6b05c0c0c3a96c22d4e737d2033aaef9c96947feb8e63c01b6f0e
description: Use a pivot table to explore and extract data.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# MDP Create a Pivot Table from Scratch

Use a pivot table to explore and extract data.

1. On the **Explore** tab, click **Pivot Tables**.
2. Click the plus (**+**) icon.
3. Add the dimensions and measurements that you want to include in the pivot table by clicking **\+ Add a Field**.
    
    By default, dimensions are placed in rows, and measurements are placed in values. You can change the format by manually dragging them to where you want. To hide a dimension or measurement from the table, hover over the field name and click the eye icon.
4. When you’re done, close the Add Data window.
5. Select the date range that you want to view data for and how to display dates.
    
    - Period name—Displays a given name for the time period. For example, naming the first 4 weeks in January “W1-W4.”
    - Period first day—Shows the first date of the selected date range in the pivot table. For example, 1 Jan 2022.
    - Period first day (calendric)—If you have a custom calendar and want to display the date range according to it, use this option.
6. To apply a filter, in the Filters section, click the **+** icon and select the filters. To quickly filter your data, click the filter icon in the relevant column in the table, and select the filters.
7. Name the pivot table.
8. To visualize your data in a chart, turn on **Visualize**.
    
    - To select which dimensions and measurements to show or to change the display, click **Chart Settings**
    - To change how the results are sorted, click **Chart Top and Sorting**.
9. To view the pivot table as a flat table, click the flat table icon.
    
    ![Flat Table Icon](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-mktg-mcidp-264-0-0-production-enus/6ea21a7c-b623-43b5-9bb1-3174d8e8301e/mcidp/images/anlyz_pivot_flattable.jpg)
10. To save, export, or download your pivot table, click **More Actions**.
11. Save your work.
    
    A pivot table can include up to 8,000 rows, and you’re notified when you reach the limit. You can either reduce the number of rows by updating the pivot table settings or adjusting the date range to narrow the results or save the pivot table and download the full results.

#### See Also

- [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.")