V
Vasco
I have some pivots that are used in several different
sheets exactly with the same format and base external
tables, where i just chenge the criteria through Microsoft
Query. The problem is that the original data from the
first pivot i used as a model, remains in the pivot all
the time. You check this because if you choose the
options "Show items with no data", all the items from my
first table model will show, even if they no longer are
part of the new criteria.
Summarizing: is there a way to remove items with no data
from a pivot field?
sheets exactly with the same format and base external
tables, where i just chenge the criteria through Microsoft
Query. The problem is that the original data from the
first pivot i used as a model, remains in the pivot all
the time. You check this because if you choose the
options "Show items with no data", all the items from my
first table model will show, even if they no longer are
part of the new criteria.
Summarizing: is there a way to remove items with no data
from a pivot field?