---
url: /excel-addin/parentcount.md
description: >-
  Retrieve the count of direct parents above an element in the provided
  dimension and hierarchy.
---

# ParentCount

Retrieve the count of direct parents above an element in the provided dimension and hierarchy.

ParentCount will count the direct parent values/parents that are one level above the provided element. Elements can appear multiple times within the same hiearchy with a different direct parent.

```js
ParentCount(applicationName, dimension, hierarchy, elementName) 
```

#### Parameters

* `applicationName` - The name of the application to work in.
* `dimension` - The dimension in which find the element.
* `hierarchy` -  The hierarchy in which find the element.
* `elementName` -  The identifier of the element for which we will return its parent count.

#### Example

```js
ParentCount("Performance Management", "Account", "Profit and Loss", "Revenue")
```

This would return the number of parent elements above the "Revenue" element in the "Profit and Loss" hierarchy.