Pivot Tables - Field data
Posted by Brent Williams on September 13, 2001 6:17 PM
When the values of a field in source data are changed, the pivot tables do not update the field, but just append the new values to the field.
For example, if a field in source data is a "month" that was represented as "1,2001" before and was changed to say "Jan 2001". The pivot table referring to that, has both 1,2001 and Jan 2001. It does not erase 1, 2001 from its memory even after refreshing data.
Also, I need the "Show items with no data" check box to be checked "yes" because I have fields with no data that I need to show.
I would really appreciate it, if somebody can help me with this!!