Pivot Table Data

[gjh]

Hi Guys

Hopefully someone can help me out!
I have created an adherence to start time pivot table but one of the data field sometime disappear from the table.

It has 2 columns - Early and Late which represents "1" and "0"
sometimes, the column shows all "Late" and doesnt show "Early" and vice versa.

I know why sometimes it shows 1 column only!

But how do I force the data field to show both columns eventhough they were late all wk or early all wk?

Thanks in advanced!

 

[lemo]

not sure what exactly is going on here, but sometimes checking
'Show items with no data'
helps.
it's somewhere in 'Field settings'.

l

 

[gjh]

Hi Lemo

I've found the option to display all the blank fields.
Thanks for the help.

The option 'Show items with no data'
was in the field itself, not in the data section.
I was right clicking in the data section instead of the fields. That explains why i couldn't find the option.

What an easy fix. Cheers, mate!