Pivot table has an item called Formula1

  • Thread starter Thread starter Laurence Lombard
  • Start date Start date
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
 
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
 
Thanks a million. Once again thw newsgroup comes up with the solution!
Laurence
 
Back
Top