Forum Discussion

MARIA K null's avatar
MARIA K null
Copper Contributor
Apr 30, 2018

Excel Pivot table help

I have a data file that has names of employees with a column for 1st level manager and second level manager.   When i create a pivot chart/pivot table and filter it to one 1st level manager, the table shows all manager names that are in the file, instead of just showing the managers that have that 1st level manager. How can I change that? 

Charting
excel
office 365

1 Reply

  • Detlef_Lewin's avatar
    Detlef_Lewin
    Silver Contributor
    Apr 30, 2018

    Maria,

     

    I presume your data looks like this:

    Name of Employee - Name of Manager 1st Level - Name of Manager 2nd Level

     

    To analyse with a pivot table you need this structure:

    Name of  Employee - Manager Type - Name of Manager

    Manager Type would be either 1st or 2nd.

     

Resources