Combining Data in Pivot Tables

[flyflyfly]

Hello,

I am trying to figure out some details in modifying data in my Pivot Table.
Here is a sample of data I have.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Course Name[/TD]
[TD]Start Date[/TD]
[TD]Location[/TD]
[TD]X[/TD]
[TD]Executives[/TD]
[TD]Managers[/TD]
[TD]Supervisors[/TD]
[/TR]
[TR]
[TD]How to..[/TD]
[TD]12/12/16[/TD]
[TD]123-K55[/TD]
[TD]X[/TD]
[TD]1[/TD]
[TD]12[/TD]
[TD]2[/TD]
[/TR]
</tbody>[/TABLE]


Now what I want to do is for the system to know that "executives, Managers, and supervisors" change into one branch "MANAGEMENT"

I have over 5000 lines of data. and for some reason it wont let me filter it by month.

Any insight in on Excel 2016?

Thanks

 

[flyflyfly]

SORRY ... I Made a Mistake..

On my data sheet
employees are listed by branch and I need a count.

IE:

JANE DOE ... Course Name ...12-Sep-16... Location ... Executive
JANE DOE ... Course Name ...12-Sep-16... Location .. Manager
JANE DOE ... Course Name ...23-Sep-16... Location .. Entry
JANE DOE ... Course Name ...12-Sep-16... Location .. Supervisor
JANE DOE ... Course Name ...12-Sep-16... Location .. .......

Etc...