How to get member aliases from row dimension set as "Children of" in Reports
Planning - Reports
Hi, I have a report with 2 row dimensions. The first row dimension is set as "Children of [Total Expenses]", the second one is set as [Total Cost Center].
[Total Expenses] is hidden, and I want to show the alias of those Children of Total Expenses in either the other dimension with Custom Heading or just create a Text Column. I've tried with MemberAlias("Account",[row number]) but it's taking the first member and then repeats that alias through the rest of rows drilled. "Heading Value" function shows the same.
Any idea how to solve this ?