Wednesday, January 20, 2010

Fill Empty Cells in Pivot table

To fill empty cels in Pivot Table with a desired value,
We need to go to pivot table options and choose -> For Empty Cells Show:

This will show all the empty cells in Pivot as the given value.

Regards,
Praveen KVC
19 January 2010

0 comments:

Post a Comment