Pivot table has an item called Formula1

L

Laurence Lombard

A pivot table has an item called Formula1, but I do not see such an item in
my list on which the table is based. What is the reason and how do I find
out what is causing it

Thanks
Laurence
 
D

Debra Dalgleish

The PivotTable contains a Calculated Item for one of the fields.
To see the formula, select a cell in the pivot table.
On the pivot toolbar, choose PivotTable>Formulas>List Formulas
This will insert a new sheet in the workbook, with a list of formulas
in the PivotTable.
The items that are used in the formula should help you determine
which field has the calculated item.
Right-click on the button for that field, and choose
Formulas>Calculated Item
From the dropdown list, choose Formula1
You can Modify or Delete the formula, then click OK
 
L

Laurence Lombard

Thanks a million. Once again thw newsgroup comes up with the solution!
Laurence
 
Top