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?
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?