Pivot Tables - standard Data Field function

K

KDJ

Hello

Is there some way to set the standard function for data fields when creating
a pivot table? Normally it is Sum, unless the Pivot Table doesn't recognise
the numbers and suggests Count.

I would like average to be the standard - is this possible?
 
D

Debra Dalgleish

No, you can't set the default summary function for the pivot table data
fields.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top