Pivot Table

[CGantz]

I need some help. I have a pivot table that I'm creating and it has a field for the Columns that I have a Column heading for but for all of the Rows the value is zero. I still want the Column heading to display but the way it works now if there are all zeros in the row it doesn't display.

Thanks

Cole

 

[koresnordic]

Sorry, do not understand the problem from your description. If you wish to send me the file, I will look at it.

gbrigden@kores.co.uk

Graham

 

[CGantz]

I'm not sure how best to describe this but let me try.

I have a table that has a range of of columns and rows that are supposed to look like this:

.60 .65 .70 .75 .80 .85 .90
R1 1 0 5 4 2 0 0
R2 8 0 3 0 0 1 9
R3 7 0 0 1 3 8 0
R4 5 0 1 2 0 0 0

When the table is displayed the column for .65 does not show because all of the values are 0. I need that column to show.

 

[koresnordic]

Ok, try this. Right click on the pivot table and select 'Table options'. You should see an option for "for empty cells show:". If this has a tick next to it - remove it. The other things to look at are: ensure you do not have any hiden columns as the data may be in there. Or ensure that you have selecte to "show all", by clicking on the down arrow immediatly to the right of both the column heading and the row heading. Failing these, the offer still stands for you to send it and I will look at it. Although it seems likely this will be first thing tommorrow morning.


Graham

 

[xlbo]

Graham - surely that would be the other way round - you want the "For Empty Cells" ticked and enter a 0 into the box provided

Other than that, I think the actual issue here is..... right click on your field header(for the column field), choose field.
At the bottom of the dialog box (that will show after selecting field) is a tick box "Show Items With No Data". Tick this and your missing column should appear. If you want to show zeros in this column instead of blanks, you will need to do as suggested above

HTH Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur

 

[CGantz]

I've tried to do both. I've entered a 0 in the "For Empty Cells" box with no effect. Also for that field the box and text for "Show Items with No Data" are greyed out and not available.

Cole

 

[Zathras]

What does your original data look like? Do you have any rows with the value .65? If not, how is Excel supposed to know that you want an extra column in the pivot table with that heading?

 

[xlbo]

I'm pretty sure that it's the Show Items With No Data option that you need

I can't even re-create your problem of that option being greyed out

Suggest you email your worksheet to either Graham or myself on
Geoff.Barraclough@Punchpubs.co.uk Rgds
Geoff

Vah! Denuone Latine loquebar? Me ineptum. Interdum modo elabitur