---
schema_version: "1"
id: 45c3a5f156373b80fca1a3160be2de232c771e680338c82b8498a7bf20564569
title: Aggregate Node
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.md
canonical_url: https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_aggregate.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: fe00ff426b1cc2bd054b8f2015d107caf0fca9cf568a32ac515ab9affbedfffa
description: Use an Aggregate node in CRM Analytics to roll up data. You can aggregate to a higher level of granularity or roll up hierarchical data.
products:
  - CRM Analytics
  - Cross Cloud
release: "264"
---
# Aggregate Node

Use an Aggregate node in CRM Analytics to roll up data. You can aggregate to a higher level of granularity or roll up hierarchical data.

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

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

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

- **[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.
- **[Aggregate Node: Hierarchical Aggregation](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_aggregate_hierarchy.htm&release=264.0.0&type=5)**  
    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.

#### 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.")
- [Aggregate Node: Hierarchical Aggregation](https://help.salesforce.com/s/articleView?id=analytics.bi_integrate_recipe_aggregate_hierarchy.htm&release=264.0.0&type=5 "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.")