Skip to main content
Answered

Report Showing Full Department Hierarchy

  • September 19, 2025
  • 2 replies
  • 19 views
S
Getting Started

Hi Folks,

I am trying to set up a report that shows a full staff list, including separate columns for departmental hierarchy, e.g:

 

First Name Last Name Business Unit Division Department
Stefan Cunning CPO P&C People Partners

 

At the moment, we have the departmental hierarchy set up through the “departments/teams” section on Personio, i.e. CPO>P&C>People Partners, but I’m not clear on how this can be pulled into an Excel showing all the subdepartments.

Any help and guidance is appreciated!

Thanks

Stefan

 

 

Best answer by SabbuSchreiber

Hi ​@Stefan C,

have you tried the people list instead of pulling a report? :-)

There you can chose which columns you want shown and filter by department and teams. If there’s a need for more attributes, you might think about using cost centers and/or creating custom attributes with i.e. drop down options for one of the organisational hierarchy attributes

Hope that helps? 😊

2 replies

SabbuSchreiber
Helping Hand
Forum|alt.badge.img+14
  • SabbuSchreiberHelping Hand
  • Helping Hand
  • 214 replies
  • Answer
  • September 19, 2025

Hi ​@Stefan C,

have you tried the people list instead of pulling a report? :-)

There you can chose which columns you want shown and filter by department and teams. If there’s a need for more attributes, you might think about using cost centers and/or creating custom attributes with i.e. drop down options for one of the organisational hierarchy attributes

Hope that helps? 😊

Moe
Community Admin
Forum|alt.badge.img+11
  • MoeCommunity Admin
  • Community Admin
  • 324 replies
  • September 23, 2025

Hi ​@Stefan C !

Has ​@SabbuSchreiber answered your question? If so, go ahead and select her comment as the Best Answer so that your fellow community members can easily find it! 


Terms & Conditions of the Personio Voyager CommunityAccessibility statement