Automatically change the field setting of 'count' to 'sum' in my Pivot table

**ACrossley1** · 02-13-2014, 03:41 PM

Hi,

I have a vast amount of data entries in a pivot table (over 100). I want to create a pivot table but when I click on it it says 'count' and not 'sum'. It will take me a long time to change them all, how do I do it quickly?

And possibly, without the 'sum of ....' in the label of it?

Thanks.

**Izandol** · 02-13-2014, 04:02 PM

Caption may not be same as field name - what will you change them to? (you may just add space, for example)

**Izandol** · 02-13-2014, 04:31 PM

Example code:

Please Login or Register  to view this content.

**ACrossley1** · 02-13-2014, 04:32 PM

When I move it from 'Axis Fields' to 'Values', it automatically makes it into 'count'. Meaning I have to change each individual one to 'sum'. I basically need a quick way to change it to 'sum'.

Thanks.