Microsoft KB Archive/212141

= XL2000: PivotTable Items Missing When Fields Are Pivoted =

Article ID: 212141

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q212141





SYMPTOMS
When you modify or pivot fields in a PivotTable, the totals may appear to return incorrect values, and some items may not be displayed in the PivotTable.



CAUSE
This behavior can occur when you do the following:
 * You create a calculated item in the PivotTable. -and-


 * You modify the PivotTable design by moving a field from the Row category to the Data category.



STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article.



MORE INFORMATION
A calculated item appears in a PivotTable only if the field on which it is based also appears. If you remove or pivot a field from either the Row or Column category into the Data category, the calculated item does not appear.

A calculated item is a user-defined item in a PivotTable field that can perform calculations by using the contents of other fields and items in the PivotTable. Calculated item formulas each include only items from the field for which you are creating the calculated item. For example, if the database contains a Region field with North and West items, you can define a calculated item named "NorthWest" by typing the following formula

=North+West

in the Region field.

