PivotTable display even without value

[SammyG83]

Hi there

I've got a pivot table counting the records for each month, however for month February there are no values in the table, but I'd like the PivotTable to display February = 0 rather than just missing the month out altogether.

Can you help?

Many thanks


Sam.x

 

[Hermanito]

In Excel 2003:
doubleclick on the Month header, then in the dialog box, tick the checkbox on the bottom left saying 'Show items with no data'.

For newer Excel versions, I expect the process will be similar...