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!
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!
Last edited: