Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display empty columns in a Pivot Table?
I have a pivot table set up with 1 page, row and column field with various
values. Basically, I want to do some math between values of my page variable (i.e. one value of my page variable is "total" and I want the percentage of that total for the other page values). This can be accomplished by making another table and using formulas and cell references. My problem is that for some page variables, I have columns with no data, so Excel hides them, so the dimensions of my table are changing. I want to be able to make Excel display all columns and rows, even if they are empty, which in effect keeps my pivot table dimensions constant. That way, I can reference the first cell in each table and fill down and across, and I will be sure that the cells are matching properly. Any ideas on how to accomplish this? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I display empty columns in a Pivot Table?
You can try right clicking on the field and selecting Field Settings - check
Show Items with No Data -- HTH... Jim Thomlinson "KBWolff" wrote: I have a pivot table set up with 1 page, row and column field with various values. Basically, I want to do some math between values of my page variable (i.e. one value of my page variable is "total" and I want the percentage of that total for the other page values). This can be accomplished by making another table and using formulas and cell references. My problem is that for some page variables, I have columns with no data, so Excel hides them, so the dimensions of my table are changing. I want to be able to make Excel display all columns and rows, even if they are empty, which in effect keeps my pivot table dimensions constant. That way, I can reference the first cell in each table and fill down and across, and I will be sure that the cells are matching properly. Any ideas on how to accomplish this? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to delete at once empty columns in a table? | Excel Discussion (Misc queries) | |||
Pivot Table counts an empty cell | Excel Discussion (Misc queries) | |||
empty lines in pivot table | Excel Discussion (Misc queries) | |||
Display columns side by Side in the Data Area of a Pivot table | Excel Discussion (Misc queries) | |||
Pivot table blank/empty cells | Excel Discussion (Misc queries) |