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

Question & Answer
, ,
1

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

2

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.

3