pivot table - Can I pre-define rows and columns?

[Guest]

Is there a way to "pre-define" the rows/columns of a PT?
If I select the data, I only get rows/columns for data that's in my source.
I would like to pre-define the rows/columns so that if there is no data in
the source, the cells would still be there but would either be blank or
contain a zero.

Thanks,
Bill

 

[Guest]

You can predefine the data range if you have the field names in place (you
can have no data, but you do need field names)

With no data, you can still set up the PT but you do need the field names.

 

[Guest]

Hmmmmm.
can you tell me how to specify the Field Names? The only way I know to do it
is to select the source data.

 

[Guest]

BTW I'm using Excel 2003

Hmmmmm.
can you tell me how to specify the Field Names? The only way I know to do it
is to select the source data.