Issue with pivot table and blanks

[uk747]

In my pivot table I have (blank) so in filter out blanks in the row labels which works fine.

However when I add more details to my table and refresh the pivot table, as I have filtered out blanks the new values added are also filtered out

 

[awoohaw]

what happens when you unfilter the table?

 

[uk747]

The blanks come back.

Found an option in field settings to
Include new items in manual filter. Then when refreshed it shows new ones added

 

[awoohaw]

so, is that good or bad for you? What happens when you applied the filter again?

 

[uk747]

That seems to resolve the issue. I can filter out blanks, add more data to the source and when pivot is refreshed the new data is in the filter and blanks are still filtered out.

Whereas before if I didn't check the option new data added was unchecked when pivot table was refreshed.

 

[awoohaw]

maybe there was an update to your current version of excel. If it works with those new steps then that is good, isn't it?

 

[uk747]

Think option has been there in lots of versions of excel, didn't realise it was there.

Would have thought default option would be to bring in new details

 

[awoohaw]

Okay, I don't use pivot tables much. But are you able to complete your task? If, not maybe a matrix based on formulas insted of a pivot report is a better solution. If, so please share your data, the xl2bb add in (link below) is the tool to share that here.

 

[uk747]

Everything ok thanks. Was confused when new data was added but didn't appear when refreshed but all ok now after checking the Include new items in manual filter option

 

[awoohaw]

okay, great. Happy to know you figured it out!