Pivot displaying 0 when there is a zero count

Is it possible for the pivot to display a 0 when there is no data for a particular label? In the example provided, when I refresh the pivot daily, there is a row label, 40918, that would reside between 40023 and 1011 in the pivot (highlighted in Yellow). But because this refresh of data does not have any data today, the column obviously does not display. This causes problems for my other links I have in place and the positioning of the rest of the data. Is there any way to solve for this issue so that it would at least insert a column with a 0 total? Thanks!


Josh

It still does not pull in the 40918 column and I'm guessing because it has not values at all that would trigger it to be brought in. Any other thoughts? Thanks Deep.


Josh

Thanks Josie, I figured that was the case. I appreciate your insight. Thanks!