---
title: Generating a Risk Aggregate Report
description: "How to set up and generate the Risk Aggregation Register report, which lists your aggregate risks and the risks linked to each one. **Applies to:** Administrators (set-up) and users assigned the report (generating) · **Module:** Register Risks ## Before You…"
url: "https://support.symbiant.co.uk/kb/generating-a-risk-aggregate-report/"
updated: "2026-10-30"
category: Risk Register Basics
tags:
  - Excel
  - Filtering
  - Spreadsheets
---

# Generating a Risk Aggregate Report

How to set up and generate the Risk Aggregation Register report, which lists your aggregate risks and the risks linked to each one.

**Applies to:** Administrators (set-up) and users assigned the report (generating) · **Module:** Register Risks

## Before You Start

The report reads the aggregate risks from one register, so keep your aggregate risks in a register of their own (in this example, **Aggregate Risks**). See [Risk Score Aggregation](https://support.symbiant.co.uk/kb/risk-score-aggregation/) for how to link risks to an aggregate risk.

**Note:** Do not link an aggregate risk to another aggregate risk, or the report will not generate.

## Setting Up the Report (Administrators)

This is a one-off step. Select **Set up** (the spanner at the bottom left), then **Reports**. Type "Aggregation" into the **Name** filter and select **Risk Aggregation Register**.

![Finding the report in Set up](https://support.symbiant.co.uk/wp-content/uploads/2026/10/generating-a-risk-aggregate-report-01-setup-reports-v2.png)

The report has two data sources, **data** and **adata**. Both need an attribute filter for the aggregate register. Without it on both, the report will not work.

![The two data sources](https://support.symbiant.co.uk/wp-content/uploads/2026/10/generating-a-risk-aggregate-report-02-data-sources.png)

Select **Functions** next to **data**, tick **Attribute Filter** and select its **Configure** link.

![Attribute Filter and Configure](https://support.symbiant.co.uk/wp-content/uploads/2026/10/generating-a-risk-aggregate-report-03-attribute-filter.png)

In the Attribute Filter window, select **AND**, then **Register** and **Select**.

![Choosing the Register attribute](https://support.symbiant.co.uk/wp-content/uploads/2026/10/generating-a-risk-aggregate-report-04-register.png)

Select **click to set value** and choose the register that holds your aggregate risks.

![Choosing the aggregate register](https://support.symbiant.co.uk/wp-content/uploads/2026/10/generating-a-risk-aggregate-report-05-value.png)

The filter reads "Register is Aggregate Risks". Select **OK**.

![Completed filter](https://support.symbiant.co.uk/wp-content/uploads/2026/10/generating-a-risk-aggregate-report-06-filter-set.png)

Repeat the same steps for the **adata** data source, then select **Save** at the top right.

![Save button](https://support.symbiant.co.uk/wp-content/uploads/2026/10/generating-a-risk-aggregate-report-07-save.png)

While you are on the report, check the **Users**, **Roles** and **Divisions** assignments so the right people can generate it.

## Generating the Report

Select **Reports** in the left-hand menu. Type "Aggregation" into the **Name** filter and select **Generate** on the **Risk Aggregation Register** row.

![Generate on the report row](https://support.symbiant.co.uk/wp-content/uploads/2026/10/generating-a-risk-aggregate-report-08-generate.png)

The Excel file downloads when it is ready. The first sheet lists the aggregate risks, and the following sheets list the risks belonging to each aggregate.

If the report fails to generate, check that the attribute filter is set on both data sources and that no aggregate risk is linked to another aggregate risk.

## Related articles

- [Risk Score Aggregation](https://support.symbiant.co.uk/kb/risk-score-aggregation/)
- [Generating a Risk Register Report](https://support.symbiant.co.uk/kb/generating-a-risk-register-report/)
- [Filtering on Reports](https://support.symbiant.co.uk/kb/filtering-on-reports/)
