How can I keep columns from dissappearing in a PIVOT?



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!


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question