Displaying of members as hierarchy/tree in pov of report
Currently we have reports which is been developed in planning instance so we have member which is been defined as POV where it would allow the users to select the member in the list. Currently all the members in the POV are showing as a single list irrespective to Parent and children view when we open report in excel but directly if we open report it is working fine.
Is there any possible way to show the Parent and children as Hierarchy structure/tree structure in the POV of report while opening report in excel?
Version (include the version you are using, if applicable):