XL2000: Wrong Values Displayed for Calculated Item in PivotTable (211703)
The information in this article applies to:
This article was previously published under Q211703 SYMPTOMS
When you manually edit a formula for a calculated item in a PivotTable, the
formula may return incorrect results.
CAUSE
This problem can occur when all of the following conditions are true:
- The PivotTable contains one or more page fields.
-and-
- You add a calculated item to the PivotTable.
-and-
- You select one of the items (other than
(All)) in the page field drop-down list.
-and-
- You manually edit the formula for the calculated item.
WORKAROUND
To work around this problem, use either of the following methods to edit
the formula for the calculated item.
Method 1
Use the Insert Calculated Item in field dialog box to edit the
formula for the calculated item. To do this, follow these steps.
- On the PivotTable toolbar, click PivotTable, point to Formulas, and then click Calculated Item.
- In the Name box, click the calculated item for which you want to change the formula.
- In the Formula box, edit the formula.
- To use the data from a item in the formula, click the field in the Fields list, and then click Insert Item.
You can include only items from the same field in which you are creating the calculated item. - Click Modify, and then click OK.
Method 2
In the Page list, click to select (All) before you edit
the formula for the calculated item.
STATUSMicrosoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. REFERENCESFor more information about about changing the formula for calculated items, click Microsoft Microsoft Excel Help on the Help menu, type Change the formula for a calculated item in a PivotTable in the Office Assistant or the Answer Wizard, and then click Search to view the topic.
| Modification Type: | Major | Last Reviewed: | 9/27/2003 |
|---|
| Keywords: | kbbug kbpending KB211703 |
|---|
|