---
title: "Use the REMOVE Modifier to Exclude One or More Dimensions"
slug: "remove-modifier"
description: "Learn how to use the REMOVE modifier in Pigment to exclude multiple Dimensions and keep your data Blocks streamlined."
tags: ["Block Management", "blocks", "Modeling Formulas", "Pigment Applications", "Pigment Blocks", "Pigment Functions", "REMOVE", "Remove Dimensions", "REMOVE modifier"]
updated: 2026-10-05T08:36:58Z
published: 2026-10-05T08:36:58Z
canonical: "kb.pigment.com/remove-modifier"
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# REMOVE modifier

## Description

Removes one or multiple Dimensions from a Block.

## Syntax

`source_block[REMOVE [aggregator]: dimension1[, dimension2]]`

- `source_block` This is Metric or List Property that is number or integer formatted, that you want to remove dimensions from.
- `aggregator` This is an optional argument where you define the aggregation methodology, the default is SUM.
- `dimension1` This is the Dimension that you wish to remove.
- `dimension2` This argument is for any additional Dimensions you would like to use, any additional Dimensions after 1 are separated by a comma.

The default aggregator, if omitted, is `SUM` for `number` objects. Other aggregators are listed here: [Aggregation Methods.](/v1/docs/aggregate-data-in-formulas)

> [!NOTE]
> ℹ️ Note
> 
> `REMOVE` is not affected by the automatic `ON` expression: the Dimensions you list after the “:” already define an explicit order. You can still write an `ON` expression to override that order with an [ordered aggregator](/v1/docs/aggregate-data-in-formulas#ordered-aggregators-and-dimension-order).

## Return type

`same as source object`

## Examples

`Revenue` is a `number` Metric with the following Dimensions: `Country`, `Product` and `Month`

| **Case** | **Results** |
| --- | --- |
| `Revenue[REMOVE SUM: Country]` | Returns the `Revenue` by `Product` and `Month` where all Countries were summed up. |
| `Revenue[REMOVE AVG: Country, Product]` | Returns the `Revenue` by `Month` with the average value of `Country` and `Product`. |
| `Revenue[REMOVE MEDIAN: Country, Product]` | Returns the `Revenue` by `Month` with the median value of `Country` and `Product`. - If the data has an **odd** number of observations, the **middle number** is selected (after arranging in ascending order) - If the data has an **even** number of observations, the **average between the two center values** is selected |
| `Revenue[REMOVE MIN: Country, Product, Month]` | Returns the minimum value of `Revenue` across all Dimensions. This is similar to using the [MINOF](/v1/docs/minof-function) function. |
| `Revenue[REMOVE STDEVS: Country, Product]` | Returns the `Revenue` by `Month`, calculating the sample standard deviation value of `Revenue` across `Country` and `Product`. |
| `Revenue[REMOVE STDEVP: Country, Product]` | Returns the `Revenue` by `Month`, calculating the population standard deviation value of `Revenue` across `Country` and `Product`. |
| `Employee.Department[REMOVE COUNTBLANK: Employee]` | Returns the number of `Employee` with empty values in the `Employee`'s `Department` Property. |

**Excel equivalent**: none

**See also**: [ADD](/v1/docs/add-modifier), [FILTER](/v1/docs/filter-modifier)

> [!TIP]
> More of a hands-on learner?
> 
> Talk to your Customer Success Manager about downloading the Functions and Modifiers in Pigment Application into your workspace. It includes examples of every formula and modifier in Pigment.

> [!NOTE]
> For detailed insights and video discussions on typical use cases and common pitfalls of the REMOVE modifier by a Pigment Solution Architect, explore the [ADD & REMOVE Modifier](https://academy.gopigment.com/add-remove-modifiers) module in the Academy.