Skip to main content
Answered

Report Showing Full Department Hierarchy

  • September 19, 2025
  • 2 Antworten
  • 0 Aufrufe

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

 

 

Beste Antwort von 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 Antworten

SabbuSchreiber
Community Superstar
Forum|alt.badge.img+15
  • Community Superstar
  • Antwort
  • 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? 😊


Mohamed A
Community Moderator Alumni
Forum|alt.badge.img+11
  • Community Moderator Alumni
  • 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!