Ancestor value from Shared hierarchy
Summary:
I have a question regarding Narrative Reporting and displaying hierarchy information in different columns.
Currently, I am using the function AncestorName("Products", true, (3)) to successfully retrieve the ancestor value from the primary hierarchy. I would like to add another column to the report that displays the corresponding ancestor name from the alternate (shared) hierarchy.
Is there a way to achieve this so that both the primary and alternate hierarchy ancestors are visible in separate columns?
Tagged:
0