changing "standard"values in turntables from sum to count

%3CLINGO-SUB%20id%3D%22lingo-sub-2980509%22%20slang%3D%22en-US%22%3Echanging%20%22standard%22values%20in%20turntables%20from%20sum%20to%20count%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2980509%22%20slang%3D%22en-US%22%3E%3CP%3EI%20use%20turntables%20a%20lot%2C%20most%20of%20the%20time%20to%20count%20values.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIn%20the%20standard%20settings%20the%20value%20is%20set%20as%20%22sum%22.%20So%20now%20i%20have%20to%20change%20that%20in%20value-field-settings%20everytime.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20save%20time%20I%20would%20like%20to%20change%20the%20standard%20settings%20(or%20an%20other%20quick%20workaround)%20.%20Any%20suggestions%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2980509%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2980643%22%20slang%3D%22en-US%22%3ERe%3A%20changing%20%22standard%22values%20in%20turntables%20from%20sum%20to%20count%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2980643%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1222781%22%20target%3D%22_blank%22%3E%40Floris64%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EThe%20default%20for%20numeric%20fields%20is%20Sum%2C%20while%20that%20for%20other%20data%20types%20such%20as%20text%20is%20Count.%20You%20cannot%20change%20that.%3C%2FP%3E%0A%3CP%3E(By%20the%20way%2C%20the%20English%20term%20for%20%22draaitabel%22%20is%20pivot%20table)%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

I use turntables a lot, most of the time to count values.

 

In the standard settings the value is set as "sum". So now i have to change that in value-field-settings everytime.

 

To save time I would like to change the standard settings (or an other quick workaround) . Any suggestions?

2 Replies

@Floris64 

The default for numeric fields is Sum, while that for other data types such as text is Count. You cannot change that.

(By the way, the English term for "draaitabel" is pivot table)

@Hans VogelaarDank je wel Hans. Helaas niet het antwoord waar ik op hoopte...maar wel waar ik al bang voor was