PDA

View Full Version : Solved: Pivot table help



debauch
02-20-2008, 10:22 AM
I have a pivot table, that has a maximum of 5 columns of data. When you change the criteria of the pivot table, if data does not exist in all 5 of those columns, it shrinks down to 2, 3, or how ever many there are.

Is there a way to force the pivot table to stay with all 5 columns everytime?? I have formula's off to the right of the table that are getting messed up each time I change the critera.