FIRSTDESCENDANTVALUE ​

Returns the first child value for a given consolidation intersection. This function only works at a consolidated level.

FIRSTDESCENDANTVALUE(dimension)

FIRSTDESCENDANTVALUE(dimension)

Parameters ​

• dimension - The dimension used to identify the first descendant value.

Examples ​

IF(ISLEAF(), CONTINUE, FIRSTDESCENDANTVALUE("Time"))

IF(ISLEAF(), CONTINUE, FIRSTDESCENDANTVALUE("Time"))

Note: If this is calculating a N-Level value it will return said value. If this is calculating a consolidation on the Time dimension it will only return the first descendants value.

If you were looking at 2020, this would return the value for 2020 - Jan.