AncestorAlias function in Management Report.

Summary:

Content (required):

Hello,

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?

Regards,

Chirag Mer

Version (include the version you are using, if applicable):

Code Snippet (add any code snippets that support your topic, if applicable):