Description
Removes one or multiple Dimensions from a Block.
Syntax
source_blockkREMOVE aggregator]: dimension11, 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 |
| 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.