How to remove dash in the pivot table when using hierarchy function to generate the parent-child relationship

[AparnaRS]

Hi Team,

I am using hierarchy function in the script to generate the parent-child relationship.
Parent can have multiple children and child can have further child and so on.

I want to show this in the pivot table. But I am getting hyphen(-) where there is no subchild for the parent.

Any help on this is much appreciated.

Attached are the screenshots.

[vinieme12]

can you post the expression you used