Pivot table values field

Resolved · Low Priority · Version 2010

Thu 29 May 2014, 16:33 Delegate Jo said...

Jo has attended:
Upgrade to Office 2010 course
Excel Advanced course

Pivot table values field

When I use this field on my machine it is defaulted to Count but Sum is a lot more useful and so always needs updating - is there a way to default this to Sum?

Fri 30 May 2014, 10:40 Trainer Gary said...

RE: Pivot table values field

Hi Jo

Thanks for getting in touch. The PivotTable will naturally change the function based on the data it sees in the column. There isn't a way to overwrite this behaviour, but have a look at the data.

A common cause of defaulting to Count is that there are text entries or error values in the data you are trying to Sum.

Have another look at the data and see if this is the case.

Kind regards

Gary Fenn
Microsoft Office Specialist Trainer

Tel: 0207 987 3777
Best STL - https://www.stl-training.co.uk
98%+ recommend us

London's leader with UK wide delivery in Microsoft Office training and management training to global brands, FTSE 100, SME's and the public sector

Fri 6 Jun 2014: Automatically marked as resolved.

Excel tip:

Pivot table grouping

If you want to group items in a pivot table together, simply highlight the labels for the fields either with the shift key (if adjacent)or with the contral key if they are not next to each other.
Right click and choose group. Give the cell a name.

When you double click on this cell it will either expamd or collapse your grouped area

View all Excel hints and tips

Pivot table values field

Pivot table values field

RE: Pivot table values field

Excel articles

Excel tip:

Pivot table grouping