Description
Filters a grid taking into account values through all dimensions. Similar to MM_FILTER, except that dimensions from the input grid are not inherited. All values from the input grid (all dimensions) are used to output the filtered grid which has no dimensions.
Syntax
=MM_FILTERDIM(Key, Output1, [Output2], [Output3], ..., [Output15])-
Key
Range that contains values (one or more dimensions) equal to 0 or 1:
- 0 to omit the value,
- 1 to return the value.
Key must have only one column.
-
Output1
First range to return and filter according to Key. Output1 can have several columns but must have at least the number of rows of Key.
-
Output2 (optional)
Second range to return and filter according to Key. Output2 can have several columns but must have at least the number of rows of Key.
-
…, Output15 (optional)
Other ranges to return and filter according to Key. The ranges can have several columns but
Remarks
- Key and output parameters need to have the same dimensions.
- The function returns a result without dimensions as dimensions are flattened.
- If you want to inherit the dimensions of the input grid to the output of the function, use the function MM_FILTER instead.
Example
We have the following input grid that has the following values for:
- Index 1 or Loop1
| Key | Value |
| 0 | 1 |
| 1 | 2 |
- Index 2 of Loop1
| Key | Value |
| 0 | 3 |
| 1 | 4 |
| 1 | 5 |
The function MM_FILTERDIM(MM_COLUMN(A2),MM_COLUMN(B2)) with A2="Key" and B2="Value" returns the following grid with no dimension (there is no dependency to Loop1):
| Value |
| 2 |
| 4 |
| 5 |