Public Schedule Face-to-Face & Online Instructor-Led Training - View dates & book

STL - Formerly Best Training Solutions Through Learning
TrustPilot
Excellent
Request Callback We will call you back
0207 987 3777 Call for assistance
Your Basket Basket is empty
pivot table values field

Forum home » Delegate support and help forum » Microsoft Excel Training and help » Pivot table values field

Pivot table values field

ResolvedVersion 2010

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?

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:

Excel 2010 Shortcuts - Start and End of the Worksheet

Did you know you can quickly move to either the beginning or the end of an Excel Worksheet using just a couple of keys on the keyboard?

Press Ctrl + Home key to move the cursor to cell A1

Press Ctrl + End key to move the cursor to the end of the current worksheet.

View all Excel hints and tips

Connect with us:

0207 987 3777

Call for assistance

Request Callback

We will call you back

Server loaded in 0.08 secs.