pivotTable question

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?

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


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

It happens all pivotTables

Is Average the default for new data fields, or row and column subtotals?

Where is the source data?

edm wrote:
> It happens all pivotTables
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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

edm wrote:
> 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
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

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.


edm wrote:
> In my XP version of Excel there is no "PivotTable
> menu, PivotTable>Formulas ". There is however in the versions before
> that, any ideas?
>
> Erle
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html