REMOVE modifier

  • Updated on Sep 24, 2025
  • 1 minute(s) read
Prev Next

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.

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 function.

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, FILTER

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.

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 module in the Academy.

Related articles