Question

when adding a pivot table comparison (analysis) field, where would you define the calculation (e.g., sum, average, count, etc.) to be used when displaying the value for a group of data?

Answer 1

Answer: When adding a pivot table comparison (analysis) field, you would define the calculation (e.g., sum, average, count, etc.) to be used when displaying the value for a group of data in the "Field Settings" dialog box.