[Cloud release: 2025.01.15]
[On-prem release: 2025 January]
[On-prem build: 25.02.07520]
Returns 1 (true) if dimension member in current row/column matches the string. Otherwise, it returns 0 (false).
Useful if you need to make conditional calculations, based on specific names or categories of your dimension. The same conditions can also be used together with color and visibility agents.
Syntax:
rowname("[string]")
colname("[string]")
Example, single level dimensions:
rowname("Rhetta Parker")
colname("Europe")
Note: The rowname() calculation only makes sense when added "as a column" or "as a new measure". Likewise, the colname() calculation only makes sense when added "as a row" or "as a new measure".
Example, multi level dimensions:
rowname("Arjuna Bolton")
rowname("Arjuna Bolton"(l1))
rowname("North America")
rowname("Madelina Hewitt"(l1)) and rowname("North America"(l2))
Comments
GREAT, great, great !!!!
Thanks for this !!!!
BR MARC
You are welcome, Marc :-)
Please sign in to leave a comment.