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.
You, Me and Dynamics GP
The premier information site for Microsoft Dynamics GP