---
schema_version: "1"
id: 25f70c2311637661c4b1733035716961825cf60a64a27889fb9a33e37e7b42f5
title: 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/dato_anlyz_pivot_create.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_anlyz_pivot_create.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 1d13f7dede92a14dc4e1b4015f068d183d62639e8cae03cbaf117b9fe1a515ad
description: Use a pivot table to explore and extract data.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Create a Pivot Table from Scratch

Use a pivot table to explore and extract data.

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
        <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="vertical-align:top;" id="d11481e38">REQUIRED USER ROLE</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="REQUIRED USER ROLE" class="slds-cell-wrap" style="vertical-align:top;" headers="d11481e38 ">To create and manage pivot tables</td>

            <td class="slds-cell-wrap" style="vertical-align:top;" headers="d11481e38 ">Admin or Power User</td>

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

1. On the **Analyze & Act** 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.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><tbody><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Period name</strong></td><td class="slds-cell-wrap">Displays a given name for the time period. For example, naming the first 4 weeks in January “W1-W4.”</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Period first day</strong></td><td class="slds-cell-wrap">Shows the first date of the selected date range in the pivot table. For example, 1 Jan 2022.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Period first day (calendric)</strong></td><td class="slds-cell-wrap">If you have a custom calendar and want to display the date range according to it, use this option.</td></tr></tbody></table>
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 header in the table, and select the filters.
7. Name the pivot table.
8. To visualize your data in a chart, turn on **Visualize**.
    
    <table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small "><tbody><tr class=""><td class="slds-cell-wrap">To select which dimensions and measurements to show or to change the chart type, click <strong class="uicontrol">Chart Settings</strong></td></tr><tr class=""><td class="slds-cell-wrap">To change how the results are sorted, click <strong class="uicontrol">Chart Top and Sorting</strong>.</td></tr></tbody></table>
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-salesforce_datorama-264-0-0-production-enus/d38a342d-dd4a-4af8-8343-f372280a75dd/salesforce_datorama/images/analyze/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

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