Mysterious Item in a pivot table field
Posted by George on November 15, 2000 12:11 PM
I have a field (company name) and if I choose "show items
with no data" in the option area i get a company which is
not even in the pivot table range.
It used to be in a previous version but it has been deleted.
And yes i have refreshed the data.
I am trying to keep the pivot tables the same size when
the page field is changed. I understand i should get companies
which aren't invlolved in one of the page choices but this phantom
company confuses me.
I know i can go in and hide it but I am not sure why it is there
in the first place and don't want to have to hide multiple phantom companies.
any thoughts would be appreciated
thanks