---
schema_version: "1"
id: 80a2664aa5b41c672253f338bf69c24396f007a2895d4e3ba3bf6d6058606c96
title: "Aggregate Node: Hierarchical Aggregation"
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/analytics/264-0-0/bi_integrate_recipe_aggregate_hierarchy.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_aggregate_hierarchy.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 5da47d8c8da1bb5d2d383e4b28f486abd24f61ec6733547885d49e0a35ee1312
description: Use Hierarchical Aggregation in CRM Analytics to sum measures across multilevel data. For example, you can roll up revenues, assets, or liabilities for companies and their subsidiaries. Or, you can roll salesperson data up the management chain to see aggregates by team, region, area, and beyond. Hierarchical Aggregation requires rows with an ID and a parent ID. Many rows can have the same parent ID, or the parent ID can be empty. Some rows can even share an ID, such as a record with multiple parents. You can also use the optional roll up percentage to apply percentage splits to allocate portions to different parents, such as commission among members of the sales team.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Aggregate Node: Hierarchical Aggregation

Use Hierarchical Aggregation in CRM Analytics to sum measures across multilevel data. For example, you can roll up revenues, assets, or liabilities for companies and their subsidiaries. Or, you can roll salesperson data up the management chain to see aggregates by team, region, area, and beyond. Hierarchical Aggregation requires rows with an ID and a parent ID. Many rows can have the same parent ID, or the parent ID can be empty. Some rows can even share an ID, such as a record with multiple parents. You can also use the optional roll up percentage to apply percentage splits to allocate portions to different parents, such as commission among members of the sales team.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note

If the data has duplicate rows with the same record ID and parent ID, you must clean the data. Run a standard aggregation before running the hierarchical aggregation.

For the same record, the amount should be consistent for all parents.

The Roll-up percentage should sum up <= 1.

<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="d184945e45">User Permissions
                Needed</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="User Permissions Needed" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e45 ">To manage and create a recipe:</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e45 ">Edit CRM Analytics Dataflows OR Edit Dataset Recipes</td>

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

1. In a Data Prep recipe that already has at least one Input node, select the Add Node button (![Add Node button](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_button_add_node.png)) between two nodes or at the end of the recipe. To show the Add Node button between two nodes, hover the cursor on the connecting line.
2. In the Add Node dialog box, select **Aggregate**.
    
    ![The Add Node modal shows all possible nodes that you can add, including the Aggregate node.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_node_aggregate.png)
3. In the Aggregate settings panel, turn on **Hierarchical Aggregation**.
    
    ![Select Hierarchical Aggregation in the Aggregate node.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_aggregate_hierarchy_select.png)
4. Add at least one **Aggregate**, such as the sum of a measure or count of rows.
    
    ![The Add Node modal shows all possible nodes that you can add, including the Aggregate node.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_aggregate_hierarchy_aggregates.png)
5. Select the **Record ID Column**. The record ID can be any dimension in the dataset that defines the row, such as salesperson or account name.
    
    ![Select a record ID column from the list of dimensions in the dataset.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_aggregate_hierarchy_recordid.png)
6. Specify the **Parent ID Column**. The parent ID identifies which record each row rolls up to. This can be any dimension in the dataset that has not been selected as the record ID, such as the manager or parent account. Not every record needs to have a parent, for instance if it’s at the top of a hierarchy.
    
    ![Select a parent ID column from the list of dimensions in the dataset.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_aggregate_hierarchy_parentid.png)
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)
    
    Note Null values are accepted in the parent ID column.
7. Optionally, select a **Roll-Up Percentage Column** to apply a percentage split. The aggregated value is multiplied by the number in this column. For example, your records have more than one parent, and you want to roll them up differently based on the parent.
    
    ![Select a Roll-Up Percentage column from the list of measures in the dataset.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_aggregate_hierarchy_percentage.png)
8. To add the Hierarchical Aggregation to the recipe, click **Apply**.
    
    ![Completed Hierarchical Aggregation setup, showing Apply button.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_aggregate_hierarchy_apply.png)
9. Save the recipe.

With hierarchical aggregation you can automatically sum values at each level of the relationship instead of calculating values manually.

![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)

Note In the following examples, **Amount** is the aggregated column.

**Example 1:** Simple hierarchy such as region and country.

This example shows:

- Multiple records with the same parent
- Mix of records with and without a parent
- A record outside of the hierarchy
- Parent with individual value

![Diagram showing hierarchy example one.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_aggregate_hierarchy_example1.png)

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
          <colgroup>
            <col style="width:11.820330969267138%">
            <col style="width:40.8983451536643%">
            <col style="width:11.820330969267138%">
            <col style="width:11.820330969267138%">
            <col style="width:11.820330969267138%">
            <col style="width:11.820330969267138%">
          </colgroup>
          <thead class="slds-text-title_caps ">
            <tr class="">
              <th scope="colgroup" class="slds-cell-wrap" colspan="3" style="vertical-align:top;" id="d184945e209">Without Hierarchical Aggregation</th>
              <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d184945e212">&nbsp;</th>
              <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d184945e214">With Hierarchical Aggregation</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">Record ID</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">Parent ID</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">Amount</td>

              <td class="slds-cell-wrap" rowspan="5" style="vertical-align:top;" headers="d184945e212 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">Record ID</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">Amount</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">A01</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">&nbsp;</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">100</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">A01</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">600</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">A02</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">A01</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">200</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">A02</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">200</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">A03</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">A01</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">300</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">A03</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">300</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">A04</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">&nbsp;</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e209 ">400</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">A04</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e214 ">400</td>

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

**Example 2** Intermediate hierarchy such as an org chart.

This example shows:

- Multiple records with the same parent
- Mix of records with and without a parent
- A record outside of the hierarchy
- Parent with individual value
- Parent without individual value
- Multiple hierarchies

![Diagram showing hierarchy example two.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_aggregate_hierarchy_example2.png)

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
          <colgroup>
            <col style="width:11.820330969267138%">
            <col style="width:40.8983451536643%">
            <col style="width:11.820330969267138%">
            <col style="width:11.820330969267138%">
            <col style="width:11.820330969267138%">
            <col style="width:11.820330969267138%">
          </colgroup>
          <thead class="slds-text-title_caps ">
            <tr class="">
              <th scope="colgroup" class="slds-cell-wrap" colspan="3" style="vertical-align:top;" id="d184945e368">Without Hierarchical Aggregation</th>
              <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d184945e371">&nbsp;</th>
              <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d184945e373">With Hierarchical Aggregation</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">Record ID</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">Parent ID</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">Amount</td>

              <td class="slds-cell-wrap" rowspan="8" style="vertical-align:top;" headers="d184945e371 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">Record ID</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">Amount</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A01</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">&nbsp;</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">100</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">A01</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">1200</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A02</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A01</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">200</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">A02</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">800</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A03</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A01</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">300</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">A03</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">300</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A04</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A05</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">400</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">A04</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">400</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A06</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A02</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">600</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">A05</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">400</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">A07</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">&nbsp;</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">700</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">A06</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">600</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">&nbsp;</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">&nbsp;</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e368 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">A07</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e373 ">700</td>

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

**Example 3** Complex hierarchy such as subsidiary ownership with split percentages.

This example shows:

- Multiple records with the same parent
- Mix of records with and without a parent
- A record outside of the hierarchy
- Parent with individual value
- Parent without individual value
- Multiple hierarchies
- Records with multiple parents
    
    ![Note](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/images/icon_note.png)
    
    Note A record has a row per each parent.
- Roll-up percentage values (percentage splits)

![Diagram showing hierarchy example three.](https://sf-zdocs-cdn-prod.zoominsoftware.com/tdta-analytics-bi-264-0-0-production-enus/ec791473-f5b4-4f64-a656-9104f455d966/resources-global/analytics/images/bi_integrate_recipe_aggregate_hierarchy_example3.png)

<table class="slds-table slds-table_bordered slds-max-medium-table_stacked slds-m-bottom_small ">
          <colgroup>
            <col style="width:10.570824524312895%">
            <col style="width:36.57505285412262%">
            <col style="width:10.570824524312895%">
            <col style="width:10.570824524312895%">
            <col style="width:10.570824524312895%">
            <col style="width:10.570824524312895%">
            <col style="width:10.570824524312895%">
          </colgroup>
          <thead class="slds-text-title_caps ">
            <tr class="">
              <th scope="colgroup" class="slds-cell-wrap" colspan="4" style="vertical-align:top;" id="d184945e588">Without Hierarchical Aggregation</th>
              <th scope="col" class="slds-cell-wrap" style="vertical-align:top;" id="d184945e591">&nbsp;</th>
              <th scope="colgroup" class="slds-cell-wrap" colspan="2" style="vertical-align:top;" id="d184945e593">With Hierarchical Aggregation</th>
            </tr>
          </thead>
          <tbody>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">Record ID</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">Parent ID</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">Amount</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">Percentage</td>

              <td class="slds-cell-wrap" rowspan="13" style="vertical-align:top;" headers="d184945e591 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">Record ID</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">Amount</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A01</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">&nbsp;</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">100</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A01</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">1375</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A02</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A01</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">200</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">1.00</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A02</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">350</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A03</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A01</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">300</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">0.50</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A03</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">1850</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A03</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A10</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">300</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">0.50</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A04</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">1290</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A04</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A05</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">400</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">1.00</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A05</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">1290</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A06</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A02</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">600</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">0.25</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A06</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">600</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A06</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A03</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">600</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">0.75</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A07</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">700</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A07</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">&nbsp;</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">700</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A08</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">890</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A08</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A04</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">800</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">1.00</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A09</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">900</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A09</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A08</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">900</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">0.10</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A10</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">1925</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A10</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">&nbsp;</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">A11</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">1100</td>

            </tr>
            <tr class="">
              <td data-label="Without Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A11</td>

              <td data-label="" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">A03</td>

              <td data-label="With Hierarchical Aggregation" class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e588 ">1.00</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">&nbsp;</td>

              <td class="slds-cell-wrap" style="vertical-align:top;" headers="d184945e593 ">&nbsp;</td>

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

#### See Also

- [Aggregate Node: Roll Up Data to a Higher Level](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_aggregate_rows.htm&release=264.0.0&type=5 "Use an Aggregate node to roll up data to a higher granularity in CRM Analytics. You can aggregate using: unique, sum, average, count, maximum, and minimum. You can group by any dimension or date column. You can also pivot dimensions as columns. For example, you can group opportunities by account to get account-level details, like total opportunity amount, average number of cases, and the average days to close an opportunity for each account. You can then pivot on account type to analyze each combination of account and account type.")