Apply Blank Pivot Table filter that will automatically include new data

**kalleway** · 04-03-2016, 07:16 AM

Hi,

I have a Pivot Table (generated from my PowerPivot data model). I have applied a filter to sort out 'blank' Names so it does not distort the results. However, if new names are added to the source, those names will not be included before re-applying the filter. Is there a better way to filter this so new data is automatically shown in the results (apart from blank values)? There is an option "Include new items in manual filter", but this only works for fields in ROWS or COLUMNS, i.e. not for the filter.

Any help is much appreciated. Thanks

**dflak** · 04-05-2016, 10:35 AM

You are correct in your observation. if you include everything in a pivot table and a new item is added to the source data, it will be included in the pivot table display. However, if you filter out anything at all and a new item is added to the source data, the new item is not displayed. if you check the filter you will see that it is checked as not visible.

What I do as a work-around is to use a helper column in the source data. Suppose the names are in Column A, then use a formula like =ISBLANK(A2). This will yield false if the column isn't blank. Call this column something like Is Blank and use it as the filter in the pivot table and set that filter to False. Blank names will be eliminated. New names will be shown.

Apply Blank Pivot Table filter that will automatically include new data

LinkBack

Thread Tools

Rate This Thread

Display

Apply Blank Pivot Table filter that will automatically include new data

Re: Apply Blank Pivot Table filter that will automatically include new data

Thread Information

Users Browsing this Thread

Similar Threads

[SOLVED] Select Automatic Report Filter in Pivot where Filter exist in Data table else select Blank

How to get pivot table to include new data added after the pivot table was created

Editing a Pivot Table to include a new column of data and filter options

Automatically Apply Macro's/Formula's and Pivot Table attributes

Apply filter in a pivot table

new rows - how can pivot table include them automatically?

[SOLVED] in a pivot table, can the average include blank entries?

Bookmarks

Bookmarks

Posting Permissions