Pivot Table basics

  • Thread starter Thread starter Art
  • Start date Start date
A

Art

Somehow I've created a column in the Pivot Table report
called "Formula 1". How do I get rid of it?

The online help sez:
"To remove a page, row, or column field, drag the field
button out of the PivotTable report." Field button? Do
they mean the buttons in the Pivot Table toolbar? There is
no "Formula 1" button. And there is no "field button" that
I can see for any of the fields in the Pivot Table report
itself.

Separate question (kind of) - is "Hiding" a column or row
the same as permanently deleting it from the Pivot Table
report?

Puzzled ....

Art
 
1) 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

2) If you Hide a field, it's like removing it from the pivot table. You
can drag it back to the pivot table to replace it.
 
Back
Top