The pivot table options includes showing or hiding cells with no values.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

RJB wrote:
Thanks, guys. Both suggestions were helpful. I have one more quandary....

I have a few weeks out of each year where I have NO sales...

For example, in Week 31 02, 03, and 04, I have nothing... So my table skips
from Week 30 to Week 32. I'd rather it put in a Week 31. Short of artifically
plugging the source spreadsheet, any thoughts?

HAVE:

WEEK 2002 2003 20004
30 52 68 71
32 39 66 42

WANT:

WEEK 2002 2003 20004
30 52 68 71
31 0 0 0
32 39 66 42