XL97: PivotTable Items Missing When Fields Are Pivoted

ID: Q168252


The information in this article applies to:
  • Microsoft Excel 97 for Windows


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 problem occurs 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 this to be a problem in the Microsoft products 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 create the calculated item. For example, if the database contains a Region field with the North and West items, you can define a calculated item named NorthWest by typing the following formula in the Region field:

=North+West


REFERENCES

For more information about performing calculations in PivotTables, click the Index tab in Microsoft Excel 97 Help, type the following text

pivottables, calculated fields
-or-
pivottables, calculated items
and then double-click the selected text to go to the "Create a calculated field in a PivotTable" or "Create a calculated item in a PivotTable" topic.

Additional query words: XL97 grand total

Keywords : xlpivot
Version : WINDOWS:97
Platform : WINDOWS
Issue type :


Last Reviewed: November 4, 1999
© 2000 Microsoft Corporation. All rights reserved. Terms of Use.