Pivot Table Value Fields

[fack7960]

Hi,

I am pulling a bunch of fields into value fields, but it automatically sets all of them to "Count".
Is there a way to make them automatically be "Average" or to change them all to "Average" at the same time? I am doing this across about 80 fields

Thanks

[newdoverman]

It appears that there isn't a way to set a default. One at a time seems to be the way it is.

[fack7960]

That's unfortunate. Is there a way to do it with a macro? I did it manually now because I was on a short time budget, but wondering for future use.

[JosephP]

you can use code

Please Login or Register  to view this content.

simply click somewhere in the pivot table and run the code