How to customize defaults in Pivot Table Values

Y

Yves

Hello,

In the pivot table field list, whenever I create a new pivot table and I am
inserting fields into the value area, I always get as default field setting
the 'Count' value. I would like to change this default to say the 'Sum'
value.
Is this possible ?

thank you

Yves
 
D

Debra Dalgleish

In a pivot table, you can't change the default function. If there are
blank cells, or cells with text, in the column, Excel will default to
the Count function when the field is added to the data area.

If the column contains only numbers, it should default to Sum.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot Table Defaults 1
Pivot table filed defaults 2
Missing values from a pivot table field 1
2007 Pivot table Calculated field misbehaving 1
Average of Subtotals in Pivot Table 0
Pivot table - Change default summarise value field. 2
Pivot Table Field based on two data area fields 3
Problem with pivot tables 1

Top