TOSUBSET modifier

Description

Converts a Parent Dimension into one of its Subsets.

Each Item in the Parent List that belongs to the Subset is naturally mapped to the corresponding Item in the Subset. Any data associated with Items in the Parent List that are not included in the Subset is simply filtered out from the final result.

ℹ️ Note

Because this Dimension modifier maps data 1:1 and neither aggregates nor allocates data, it does not require you to specify an aggregator or allocator in the syntax.

Syntax

Expression[TOSUBSET : Subset]

• Expression:  Any valid formula expression that is currently dimensioned by the Parent List.

• Subset: The specific Subset Dimension you are converting the Parent Dimension to.

Return type

same as expression return type

Example

In this example, we have a Parent List called Country and a Subset of that List called EMEA Country.

We want to take a Metric called Sales Target (which is dimensioned by Country) and convert it so that it is dimensioned by the EMEA Country subset instead.

Dimensions Setup:

Source Metric: Sales Target  (Dimensioned by: Country)

Formula:   'Sales Target'[TOSUBSET: 'EMEA Country']

Excel equivalent: none

See also: TOPARENTLIST