Pivot Table - Exclude Values Containing Certain Text

Sundance_Kid

Board Regular
Joined
Sep 2, 2017
Messages
94
Office Version
  1. 365
Platform
  1. Windows
Hi,

I have a pivot table and one of the fields has around 1,000 rows, with all different names, each name is typically a 3 word name.

However, there is a certain word that will appear in a handful of the rows upon which I want to exclude/filter out these rows from my pivot table.

The tedious way is to go down row by row and untick the row, is there any other options that are quick and easy? Like

If I had the raw data, I would just add an additional column to the raw data doing a search for the rows with the specific word and mark it so it would be easy to exclude in the pivot table, however the issue here is that the data is coming from other sources - from analysis services so it is a connection to some sort of Cube. So I don't have the raw data but the pivot table connects to the data but I can only work with the pivot table & not the raw data.

Thanks
 

Excel Facts

Quick Sum
Select a range of cells. The total appears in bottom right of Excel screen. Right-click total to add Max, Min, Count, Average.

Forum statistics

Threads
1,181,764
Messages
5,931,910
Members
436,808
Latest member
Dalton50

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top