# HIDDENTEXT

#### Syntax <a href="#syntax.14" id="syntax.14"></a>

**HIDDENTEXT**(*member*)

* *member* - the *member* value, from which the hidden text should be returned - ***Value type**: member*

#### Remarks <a href="#remarks.11" id="remarks.11"></a>

* See the description of the function [CREATEMEMBER ](https://docs.nedyx.com/version-1.52-preview/clearlines-functions/text-functions/createmember)to get more information about member value types.

#### Examples

In this example, the *memberTable* has been created by the function CREATEMEMBER, based on the tables *displayTexts* and *hiddenTexts*. Then the function HIDDENTEXT can be used later to extract the hidden texts from *memberTable*.&#x20;

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/R4Mvi9WyholvFdbi6wnT/image.png" alt=""><figcaption></figcaption></figure>

In this example, the HIDDENTEXT function returns the unique texts from dimension elements coming from Analysis Services.

<figure><img src="https://content.gitbook.com/content/4X6nN2wTlDsVpd8P1WDM/blobs/pPRGrzLT2QGu0oPg3esD/image.png" alt=""><figcaption></figcaption></figure>