How to show 0 instead of blank in pivot table where records does not exist

Hi,

I have a Pivot table with Region and Product Name as Rows and Month of the years as column to show total amount of sales for the product in a give month in the region.

The products which do not have sales record in particular month in particular region is displayed as blanks. Is there a way to show this as 0 and not blank. I tried isNull and Coalesce functions, however they don’t seem to work since the records are non existent and not null.

Any help would be appreciated.

Thank you,
Arth

This is not possible. I can mark it as a feature request.

The workaround would be to make a SQL calendar and join data onto it.