Pivot table "not equal to" filter

jzeunik

New Member
Joined
Mar 28, 2011
Messages
11
I have a pivot table that is filtered based on a single value in a table column. Let's say it's Column G, which has either a Y or N for each row. The pivot table is filtered for the Y values. Each month, the table is refreshed with new data, and the pivot table is also refreshed. However, in some months, there are no rows with Y values, so the pivot table filter "breaks" when it is refreshed. So, the pivot table is effectively unfiltered, and includes all rows of data.

The ideal would be to filter Column G for values not equal to N, so the filter would be valid even in months with no Y values. Is there a way to do this kind of filtering in a pivot table?
 

Some videos you may like

Excel Facts

Remove leading & trailing spaces
Save as CSV to remove all leading and trailing spaces. It is faster than using TRIM().

Watch MrExcel Video

Forum statistics

Threads
1,114,665
Messages
5,549,305
Members
410,908
Latest member
Allen P
Top