displaying zeros when no value in pivot table

[markcranmer]

I have a pivot table consisting of two instances of test scores. The column on the left is grouped by increments of 10, in a range of 0-100, and the column on the right is a 'count' of the number of tests within each increment.

There are no test results in the increments 1-10 and 11-20 but by ticking the 'Show items with no data' box in Field Settings/Layout and Print dialogue box, for the left-hand column, I can ensure that the first two increments on the left column are displayed.

However the 'Count' entries on the right-hand column for these increments is blank, instead of displaying zeros. There is no 'Layout and Print' tab in the 'Values Field Settings' dialogue box, so I can't 'show items with no data' specifically for the right-hand column (which is a values column).

Hope that makes sense.

thanks,
Mark

[markcranmer]

Oh, I've just sorted this. I right-clicked the pivot table and entered 0 in the 'For empty cells show:' box.

It was remiss of me not to mention that I am using Excel 2007.

mark