---
title: "TOSUBSET modifier"
slug: "tosubset-modifier"
updated: 2026-04-06T12:45:51Z
published: 2026-04-06T12:45:51Z
---

> ## Documentation Index
> Fetch the complete documentation index at: https://kb.pigment.com/llms.txt
> Use this file to discover all available pages before exploring further.

# 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]
> ℹ️ 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:**

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(302).png)

**Source Metric:**`Sales Target` *(Dimensioned by: Country)*

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(303).png)

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

![](https://cdn.document360.io/e47cfe35-dc28-40c7-a083-6cf003073d8e/Images/Documentation/image(304).png)

**Excel equivalent**: none

**See also**: [TOPARENTLIST](/v1/docs/toparentlist-modifier)