---
schema_version: "1"
id: 480f09efb99d97db283ebdcfee9422fd74094b5a7275ceea5ad40257ed3f7cb2
title: Aggregate Node
collection: admin
version: current
locale: en-us
portal_url: https://docs.salesforce.com/admin/current/en-us/data/264-0-0/c360_a_batch_transform_aggregate.md
canonical_url: https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_aggregate.htm&release=264.0.0&type=5
source_site: help.salesforce.com
content_type: documentation
content_hash: 64d75541edf896cefaccb751628bc5e0ee2f4b0d351c74b870ecadfb376c077f
description: Use an Aggregate node to roll up data. You can aggregate to a higher level of granularity or roll up hierarchical data.
products:
  - Data 360
release: "264"
---
# Aggregate Node

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

- **[Aggregate Node: Roll Up Data to a Higher Level](https://help.salesforce.com/s/articleView?id=data.c360_a_batch_transform_aggregate_roll.htm&release=264.0.0&type=5)**  
    Use an Aggregate node to roll up data to a higher granularity. 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=data.c360_a_batch_transform_aggregate_hierarchy.htm&release=264.0.0&type=5)**  
    Use Hierarchical Aggregation 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.