Crosswords0 min ago
Pivot Tables
1 Answers
Q1. Why do pivot tables always choose count instead of sum? Drives me up the wall! I can't be the only one to find this, surely?
Q2. Why do they often have a blank category in a row or column for no apparent reason?
Q2. Why do they often have a blank category in a row or column for no apparent reason?
Answers
Only 1 answer
Best Answer
No best answer has yet been selected by tell-me-more. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.
These are just the default settings.
I would imagine that MS research their defaults and set them to what they reckon will be the most commonly used.
Personally speaking I am happy that the Data defaults to Count rather than Sum. I guess it just depends on your requirements
blank needs to be included - so that if there are blanks in the data set being pivotted then they can be counted.
If it wasn't there - it would cause confusion as the total of count would not match the number of rows in the data set.
I would imagine that MS research their defaults and set them to what they reckon will be the most commonly used.
Personally speaking I am happy that the Data defaults to Count rather than Sum. I guess it just depends on your requirements
blank needs to be included - so that if there are blanks in the data set being pivotted then they can be counted.
If it wasn't there - it would cause confusion as the total of count would not match the number of rows in the data set.
Only 1 answer
