The information in this article applies to:
SYMPTOMSWhen 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:
-and- STATUSMicrosoft 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.
REFERENCESFor 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 itemsand 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 |
Last Reviewed: November 4, 1999 © 2000 Microsoft Corporation. All rights reserved. Terms of Use. |