| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
pivot table - Can I pre-define rows and columns?
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 |
|
#2
|
|||
|
|||
|
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. -- Kind Regards, Will Riley "WRBailey" wrote: 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 |
|
#3
|
|||
|
|||
|
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. "WillR" wrote: 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. -- Kind Regards, Will Riley "WRBailey" wrote: 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 |
|
#4
|
|||
|
|||
|
BTW I'm using Excel 2003
"WRBailey" wrote: 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. "WillR" wrote: 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. -- Kind Regards, Will Riley "WRBailey" wrote: 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) | |||
| Change data to appear in rows instead of columns (reverse a table. | Excel Discussion (Misc queries) | |||
| How to have multiple columns in pivot table data area? | Excel Worksheet Functions | |||
| How to get pivot table data columns instead of rows | Excel Discussion (Misc queries) | |||
| Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
Hybrid Mode
