Pivot table filters

[dmfweb]

I have the dumbest question and I am embarrassed to ask it... but here I am...
I have a pivot table and I need to remove a certain type of data... but there are 30,000 lines of data.

Question: I don't want to count any data that has the word "intern" in it.
This seems simple to me, but since I am not showing that data in the pivot, I moved the 'description' column data to the "Filters" section of the pivot, but I can figure out to how EXCLUDE anything with the word intern. It seems so basic, but I don't see a way.


Microsoft® Excel for Mac
Version 16.86
365

 

[arun_eagertolearn]

Hi

Can you please make the descriptions a part of the column filter in the pivot table, there you would be able to exclude

Or add a helper column in the base data, which classified entries into those with 'Intern' and those without 'Intern'

 

[dmfweb]

Hi

Can you please make the descriptions a part of the column filter in the pivot table, there you would be able to exclude

Or add a helper column in the base data, which classified entries into those with 'Intern' and those without 'Intern'

I guess I can do that... I figured with as powerful as excel is there must be an EXCLUDE option I was missing... Thank you