Multiple keyword filters within Pivot Table in Excel 2016

[mSolver]

For instance, I have a whole range of job roles and the count, and I want to group several functions together, such as:

Group 1
Sales
Marketing
Business
BD
Business Development

Group 2
Admin
Administrative
Accounts

how do I filter and group them together easily as long as the job role contains 1 of these words?

In addition, why is it that Advanced filters is greyed out when I click on any row within the Pivot Table?

Good if there's a video illustration, otherwise steps will be appreciated. Thank you!

[Pepe Le Mokko]

Welcome to the forum

Please attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.