veeyeskay has a great look at Filling Blank Cells in a Pivot Table. I just recently stumbled across something similar from Mr. Excel, Bill Jelen. This is a nice reminder.
Excel Pivot Table – Filling Blank Cells
Archived post from 2011. Dynamics GP and the links it points to have changed since; check current documentation before relying on version-specific steps.