How can I keep columns from dissappearing in a PIVOT?

[Guest]

We use a pivot to filter data that then feeds additional reporting. We set
the pivot up to see all data, and have tied formulas to cells within that
column structure. When we filter on a region that does not have data for a
particular column, that column dissappears, throwing off all of the formulas
tied to the original column structure. How can I have the pivot remain
static - for example, if I choose to add the columns DATA1, DATA2, DATA3 to
the pivot, I want to see those columns, even if a filter is applied and no
data can be displayed under them.

Thank you!

 

[Guest]

pa1971;

Create a static column with all values set to a pre determine factor. This
will keep one open reference to each factor. All of the required data will
occur. You may have to include an

=if(a1="",0[ or equals na() as your formula needs!],RemainderOfFormula)

to keep from throwing errors thru out your worksheet.

God Bless

Frank Pytel

http://groups.google.com/group/excel-applications-and-spreadsheet-programming