Skip to main content
Answered

Report Showing Full Department Hierarchy

  • Sept. 19, 2025 11:11 AM UTC
  • 2 Antworten
  • 12 Aufrufe
  • Alles übersetzen

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? 😊

Zum Originalpost

2 Antworten

SabbuSchreiber
Community Superstar
Forum|alt.badge.img+15
  • Community Superstar
  • Antwort
  • Sept. 19, 2025 11:17 AM UTC

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? 😊

Übersetzen

Mohamed A
Community Moderator Alumni
Forum|alt.badge.img+12
  • Community Moderator Alumni
  • Sept. 23, 2025 7:53 AM UTC

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! 

Übersetzen