pivotTable question

  • Thread starter Thread starter edm
  • Start date Start date
E

edm

The default for the PivotTable field has somehow become average and not
sum. How do I change it back?

Erle
 
There's no setting to change the default calculation.

Does this happen in just one pivot table, or all pivot tables?
Is this the default for new data fields, or row and column subtotals?
 
Is Average the default for new data fields, or row and column subtotals?

Where is the source data?
 
I will be in the office tomarrow and I will check into the computers
that it happens on and write back then, thanks.
 
The problem is when I go into the layout section of thw wizard and drag
fields into the Data Section.

Could it be that Excel dosn't recognize the feilds as nimeric?


Also, if we are already asking questions, when right clicking a feild
in the Data section is it possible that Excel XP lost the "Formulas"
menu entry?

Thanks loads

Erle
 
If Excel doesn't recognize the fields as numeric, is should add them to
the data area as "Count of...".

To convert the values in the source table to real numbers, you can use
one of techniques shown here:

http://www.contextures.com/xlDataEntry03.html

To create a Calculated Field, or Calculated Item, go to the PivotTable
menu, and choose PivotTable>Formulas
 
In my XP version of Excel there is no "PivotTable
menu, PivotTable>Formulas ". There is however in the versions before
that, any ideas?

Erle
 
Perhaps you have short menus enabled. To change this --

Choose Tools>Customize
Select the Options tab
Add a check mark to 'Always show full menus'
Click OK

Or, to use short menus, and see commands that you haven't used recently,
open a menu, and point to the arrow at the bottom of the menu.

If that doesn't work, try resetting the Menu bar (if you have customized
the Menu bar, the customizations will be lost):

Choose Tools>Customize
On the Toolbars tab, select the Worksheet Menu Bar
Click the Reset button
Click OK to confirm the Reset
Close the Customize dialog box.
 
Back
Top