My Pivot Table & The Missing Zeros
Posted by Ben Posaner on April 30, 2001 7:19 AM
When I pivot my data using the wizard and put one of my variables on the"PAGE" choice it builds the pivot table no problem. It gives me a drop down box that allows me to select the different variables and then re-draws the table. When I sellect "ALL" its fine, but if I select the individual variables and if there are blanks in the data it re-draws the pivot table & will miss out empty rows and so the number of rows changes.
I've tried the bit in the wizard which allows you to swap blanks, I put in 0's, which it does, but when I chnage the variable choice it still skips the blanks.
Basically I want to change the variable in the drop down and it redraw the table blanks & all.
Am I missing something silly? I there a box I need to tick???
Thanks for any help.