Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
pivot table dummy values?
I have column headings (and sub-headings) that I want to remain in my pivot
table, even though there are no data values for them in my raw data. But when I create a pivot table, the headings without data values are automatically removed from the table. Is there a way to ensure a complete table (all column heading and sub-headings) without having to add dummy values (zeros) to the raw data itself? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot table values | Excel Discussion (Misc queries) | |||
Pivot table zero values | Excel Discussion (Misc queries) | |||
Dummy series and data table | Charts and Charting in Excel | |||
Copying values from pivot table to cells outside pivot table | Excel Discussion (Misc queries) | |||
dummy alert - divide values by values | Excel Discussion (Misc queries) |