AncestorAlias function in Management Report.
We have a requirement where client wants to see the level 4 on first column, level 3 on the second column and so on till level 0.
I tried the AncestorAlias or AncestorName function to resolve the issue, however this function is returning only immediate ancestor rather than whole hierarchy. Please see the attached screenshot. I am not able to use this function for the multiple rows, at a time I can give only single row for a reference. Any workaround for this?
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):