I have a couple of Pivot tables on the same page that are linked together.
Under the Pivots, I am referencing data from the pivot cells into detailed
calculations below. My issue is, when there is not data in a column, the
pivot automatically deletes the column and throws off all of my calculations
below. I'm sure there is some
VB code that I can write to prevent this, and
have the Pivot include a null space, but I do not know how to do this. Any
suggestions?
Thank you.