maintain the same number of columns even without data

Hi Gurus,

How do I maintain the same number of column?

Currently the pivot table has 11 columns,
Row 1 (EMP02) has 11 columns of data;
Row 2 (LSC01) has 4 columns of data.
snap0781.gif


If I filter only by LSC01, then the column pivot table will be dynamically show only 4 columns.
snap0782.gif


How it is possible to select only LSC01, but maintain 11 columns like below (without adding zero dummy data into the source)?
snap0783.gif

I tried "For Empty Cell show: 0" still won't help
snap0784.gif

What I need is to show all columns available, if filtered column without data should remain as zero

I am using Office 2007, and I couldn't find the option that you are referring to. Please advise

snap0785.gif
I think I found it, but it is disabled for some reason, any idea?

Okay, nvm, I just found it, thanks for the tips! appreciate that

snap0792.gif
here is where I found it