Blank records are not appearing in the pivot

[acpt22]

I have an excel table as below from where I am generating a pivot table:


----------------------------------------------------------------------

Region Project Name Is this a new Project?

----------------------------------------------------------------------


CE AA Yes


CE BB No


ESE CC No


ME DD Yes


WE EE


ESE FF


WE GG No


ME HH


CE II Yes


The pivot looks like this:


http://www.imagetoo.com/images/pivot.jpg


I just need to show the records which are "New Projects" (for which "Is this a New Project?" is "Yes"). Hence I am filtering the pivot for "Yes" records only.


Not all regions are appearing. I also need to show other regions which are missing (viz,ESE & WE) with 0 values.


How do i do it?

 

[bobhc]

Good day acpt22


Could you upload your workbook to Dropbox, your link does not work even with the [IMG[[/IMG]stripped out, it also make's it easier to try and find an answer with live data. If you have sensitive data strip it out and replace with dummy data.

 

[acpt22]

Crossposting done here ->


http://www.mrexcel.com/forum/excel-questions/703346-blank-records-not-being-appearing-pivot.html#post3473676

 

[acpt22]

Bobhc


I have edited the HTML tags. It should look better now.

Will try to upload the sample file.


Meanwhile, please provide a solution on the above post.

 

[bobhc]

Good day acpt show22


I had already copied and removed tags and turned to table and pivot. The blanks are showing but do not show as such as there is nothing to show they are blank, the Region and Project Name show as there is data there but the Yes/no do not as they are "empty".

When I filter on yes in the pivot table only those with yes show.


https://dl.dropboxusercontent.com/u/75495784/acpt22.xlsx