Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
can you post the expression you used