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.

Course Name	Start Date	Location	X	Executives	Managers	Supervisors
How to..	12/12/16	123-K55	X	1	12	2

<tbody>
</tbody>

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...