---
schema_version: "1"
id: 6ab63d2a51c6fb4b5ef50d6a1cc28d2485951462a8d6e91ce16bcc3e2b127a35
title: Create a Calculated Dimension from the Calculated Dimension Tab
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/mktg/264-0-0/dato_dimensions_calculated_create.md
canonical_url: https://help.salesforce.com/s/articleView?id=mktg.dato_dimensions_calculated_create.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 6d74fedc3008e8c4d02432a8325fbcf38c6332b38917091c1447b682448c0d5e
description: Create calculated dimensions on top of existing data and refer to them across your workspace.
products:
  - Marketing
  - Marketing Cloud Intelligence
release: "264"
---
# Create a Calculated Dimension from the Calculated Dimension Tab

Create calculated dimensions on top of existing data and refer to them across your workspace.

### 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:center;vertical-align:top;" id="d49385e38">User Permissions Needed</th>
          </tr>
        </thead>
        <tbody>
          <tr class="">
            <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d49385e38 ">Create and manage calculated dimensions</td>

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

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

1. On the **Connect & Mix** tab, expand **Dimensions**, and then expand **Calculated Dimensions**.
2. Click **Add New**.
3. In the **General** section, name the dimension, add a description, and select the type.
    
    The type affects the format in the widget settings. In most cases, select **Text**.
4. In the **Advanced** section, you can link a measurement to the calculated dimension’s formula to populate lists with the dimension’s values. For example, you have a calculated dimension that returns an email name with the related measurement of clicks. When the calculated dimension is used in a widget, the returned email name values are only emails that had at least one click within the date range that the page is filtered on. If no related measurement is used, all email names are returned, including those without clicks.
5. To hide widgets that contain the calculated dimension from users who don’t have Admin or Power User permissions, select **Invisible Dimension**.
6. In the **Expression** section, enter the expression that you want to base the calculated dimension on. For example, if your customers’ email names consist of multiple concatenated values, you can create a calculated dimension to extract the values and create fields using the formula `EXTRACT([Email_Name],'_',1)`.
    1. Create an expression using the list of available dimensions and functions. To add a function to your expression, click it or start typing for auto-complete.
    2. Apply any of the options that appear at the bottom of the screen.
        
        <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">Full Screen</strong></td><td class="slds-cell-wrap">View the expression section in full-screen mode.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Auto Format</strong></td><td class="slds-cell-wrap">Format your code into the standard correct structure.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Comment</strong></td><td class="slds-cell-wrap">Enter a comment within your expression.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Uncomment</strong></td><td class="slds-cell-wrap">Remove your comment from the expression.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Code Validation</strong></td><td class="slds-cell-wrap">Validate that your expression is accurate.</td></tr><tr class=""><td class="slds-cell-wrap"><strong class="uicontrol">Test</strong></td><td class="slds-cell-wrap">Test your expression.</td></tr></tbody></table>
7. Click **Save**