# Configure drilldown reports

> Open an aggregated value to see the records behind it, then customize fields, filters, and conditional formatting or save the drilldown as a report.

When you aggregate the data in a report, you can click on any aggregated value to drill down and view the details behind it. For example, if your report calculates the average annual compensation in each department, you can click on each department’s average to drill down and view details about the individual salaries that make up that total.

You can customize report drilldowns while viewing them so they include your preferred level of detail. If you want to save the changes you make, you can save them as separate reports.

## How drilldowns work

Drilldown reports are generated on the fly, with filters derived from the specific data point you clicked.

-   Any additional filters or conditional formatting you apply while viewing a drilldown are retained only within that particular viewing session. They are not preserved when you exit the drilldown view.
-   You can use **Save as** to save the drilldown as a new standalone report with your customizations. That saved report will be independent and has no link back to the source report's drilldown behavior.

## Customize a report drilldown

You can customize the drilldown in your report in the following ways:

-   Remove fields you don’t want to see.
-   Add fields that are not in the main report.
-   Add filters that are not in the main report.
-   Add conditional formatting.

To remove fields from a drilldown:

1.  Open your report for editing.
2.  Select the **Settings** tab, **Drilldown** option.
3.  Click the X next to a field to remove it from the drilldown.

The field is removed and will no longer appear in the drilldown report. Note that it is only removed from the display. The field will remain in the _Selected fields_ area of the report, and will still be included in the report calculations.

To add a field to a drilldown:

1.  With the **Settings** > **Drilldown** option selected, open the _Available data_ panel.
2.  Locate the field you want to add and drag it into the area that says **Drag fields here**.

The field will be added to the drilldown report. It will also be added to the _Selected fields_ area of the report.

### Add a filter to a drilldown

While viewing a drilldown report, you can apply more filters. You can use any field that’s in the _Selected fields_ area of the main report as a filter.

To add a filter to a drilldown, follow these steps:

1.  Make sure the field you want to use as your filter is present in the _Selected fields_ area of the report.
2.  Click into an aggregated value to open the drilldown view.
3.  Open the filters panel at the top of the report and click **\+ Add filter**.
4.  Select the field and set the filter criteria.

Note that you cannot remove filters that are applied in the source report from the drilldown view.

For more information, see [Filters and time frames in reports](https://developer.rippling.com/documentation/rippling-platform/reports/filters).

### Add conditional formatting to a drilldown

You can add conditional formatting in a drilldown to visually highlight values that meet criteria you specify. To add conditional formatting, follow these steps:

1.  While viewing the drilldown, locate the column to which you want to apply formatting.
2.  Click the down arrow in the column header and select **Conditional formatting**.
3.  Add your conditional formatting rules. For more information, see [Get started with reports](https://developer.rippling.com/documentation/rippling-platform/reports/getting-started#apply-conditional-formatting).

### Save a drilldown as a separate report

You can also save a drilldown as a separate report that’s accessible from the dashboard in the Reports and Dashboards app. You may want to do this if you’ve applied customizations that you want to preserve in a new report.

To save a drilldown as a separate report, follow these steps:

1.  Click **Save as** in the top right corner.
2.  Give the report a name.
3.  Click **Save**.

The report is saved and opens in the Reports editor. You’ll also find it at the top of the _Recent_ and _Created by me_ tabs in the Reports and Dashboards app.

## See also

-   [Get started with reports](https://developer.rippling.com/documentation/rippling-platform/reports/getting-started)
-   [Filters and time frames in reports](https://developer.rippling.com/documentation/rippling-platform/reports/filters)
-   [Charts and grouping in reports](https://developer.rippling.com/documentation/rippling-platform/reports/visualization)
-   [Apply formatting to numbers or dates](https://developer.rippling.com/documentation/rippling-platform/reports/formatting)

Source: https://developer.rippling.com/documentation/rippling-platform/reports/drilldowns

> For the complete documentation index, see [llms.txt](https://developer.rippling.com/llms.txt). Public pages have a Markdown version at the same URL with .md added.
