Pivot Table - Extracting specific data
 

I have a pivot table that has employees names , showing course hours
completed, needed, etc.. On this pivot table I also have the employees
managers they report to. My issue is I need to only show the employees that
report to managers that are a specific level. On my spreadsheet I have job
description for all, how do I only show the employees that report to the
managers that are that specfic level, along with showing the hours completed
and needed per employee for that manager ? This is for weekly Team reporting

On your worksheet with the data source, create a 'cheat' column. In that
column, create an 'if' formula that identifies the folks you want to see in
the pivot table with "Yes" and all others as "No". Re-define the pivot table
to include this new column in the 'Page' section of the pivot table. Select
only 'Yes".
An example of a formula is...
=If(B2=7,"Yes","No") where B contains the Manager Level and you are
looking for managers with a level of 7.

HTH.
--
Gary Brown

Please rate this posting if it is helpful to you.


"JT" wrote:

I have a pivot table that has employees names , showing course hours
completed, needed, etc.. On this pivot table I also have the employees
managers they report to. My issue is I need to only show the employees that
report to managers that are a specific level. On my spreadsheet I have job
description for all, how do I only show the employees that report to the
managers that are that specfic level, along with showing the hours completed
and needed per employee for that manager ? This is for weekly Team reporting

The data source I am using has employee names in one column, than anther
column who they report to . I need to identify the employees that report to
specific managers without having to do this manually or filtering out
managers I do not need to report on.. The if formula would work if I am
looking at the employees level, but to identify if their manager is a
specific level

"Gary Brown" wrote:

On your worksheet with the data source, create a 'cheat' column. In that
column, create an 'if' formula that identifies the folks you want to see in
the pivot table with "Yes" and all others as "No". Re-define the pivot table
to include this new column in the 'Page' section of the pivot table. Select
only 'Yes".
An example of a formula is...
=If(B2=7,"Yes","No") where B contains the Manager Level and you are
looking for managers with a level of 7.

HTH.
--
Gary Brown

Please rate this posting if it is helpful to you.


"JT" wrote:

I have a pivot table that has employees names , showing course hours
completed, needed, etc.. On this pivot table I also have the employees
managers they report to. My issue is I need to only show the employees that
report to managers that are a specific level. On my spreadsheet I have job
description for all, how do I only show the employees that report to the
managers that are that specfic level, along with showing the hours completed
and needed per employee for that manager ? This is for weekly Team reporting