---
title: "TOPARENTLIST modifier"
slug: "toparentlist-modifier"
updated: 2026-04-06T12:42:17Z
published: 2026-04-06T12:42:17Z
canonical: "kb.pigment.com/toparentlist-modifier"
---

> ## 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.

# TOPARENTLIST modifier

## Description

Converts a Subset Dimension into its Parent Dimension.

Each Item in the Subset is naturally mapped to the corresponding Item in the Parent List. Any Items in the Parent List that are not included in the Subset return a blank value.

> [!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[TOPARENTLIST : Subset]`

- `Expression`: Any valid formula expression that is currently dimensioned by the Subset.
- `Subset`: The specific Subset Dimension you are converting to its Parent Dimension.

## 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 `EMEA Sales Target` (which is dimensioned by the **EMEA Country** subset) and convert it so that it is dimensioned by the full **Country** list instead.

**Dimensions Setup:**

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

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

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

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

**Result:** *(Dimensioned by: Country)*

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

**Excel equivalent**: none

**See also**: [TOSUBSET](/v1/docs/tosubset-modifier)