How can I keep columns from dissappearing in a PIVOT?

  • Thread starter Thread starter Guest
  • Start date Start date
G

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!
 
Back
Top