MemberName
MemberName
returns the name of the member assigned to a dimension in the grid row or column.
Syntax:
MemberName("Grid", "Dimension", Row/Col,
Qualified
)
-
The following syntax returns the name of a row or column heading. The syntax can be deployed from any heading cell, text cell, or text box object and can reference any grid in a current report.
MemberName ("Dimension")
-
The following syntax returns the name of a POV. The syntax can be deployed from any text cell or text box object and can reference any grid and corresponding POV in a current report.
MemberName
("Grid"
,"Dimension"
)
Note:
See Parameters for Text Functions for parameter definitions.
Examples:
Return the name assigned to the Product dimension in Grid1, column A:
MemberName("Grid1", "Product", A)
Return the name for the Year dimension. The syntax is placed on the grid’s custom heading:
MemberName("Year")
Return the name for the Scenario dimension for the POV associated with Grid1:
MemberName("Grid1", "Scenario")