| 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 |
| 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) | |||
Threaded Mode
