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