Is there a way to show the immediate parent department in a department saved search without using summary groups? Through regex and rtrim applied to department's hierarchical name, I was able to pick up the top parent department but what I need is the immediate parent instead. Ex. Grandparent : Parent : Child (3-level) Expected Result is Parent.

SUBSTR(SUBSTR({department}, INST({department}, ‘:’), 300), 2, INST({department}, ‘:’))

Thank you!