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