Description
Removes one or multiple Dimensions from a Block.
Syntax
source_block[REMOVE [aggregator]: dimension1[, dimension2]]
source_blockThis 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 |
|
| Returns the |
|
| Returns the |
|
| Returns the minimum value of |
|
| Returns the number of |
Excel equivalent: none
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.