In what situations would you change the default data field calculations settings of a PivotTable?
What will be an ideal response?
The ability to vary data field calculations is one of the strengths of PivotTables. They are best used in situations in which the default calculation settings would yield misleading results. For example when evaluating survey results based on age ranges in which each age group is not equally represented in the results. If the value fields are set to sum, this will yield results the lean towards the largest represented group.
Computer Science & Information Technology
You might also like to view...
A SharePoint subsite is also known as a child site
Indicate whether the statement is true or false
Computer Science & Information Technology
Which of the following will count down from 10 to 1 correctly?
a. for (int j = 10; j <= 1; j++) b. for (int j = 1; j <= 10; j++) c. for (int j = 10; j > 1; j--) d. for (int j = 10; j >= 1; j--)
Computer Science & Information Technology