A list consists of the following columns: customer id,customer income,total annual expenditure,and annual expenditure on food.While creating a pivot table,which of the following fields would require clicking on "Count" in the "Values" field setting?
A)Customer id
B)Customer income
C)Total annual expenditure
D)Annual expenditure on food

Question

Quizplus · Accepted Answer

When you drop information into the "Values" area in a skeletal structure of a pivot table,the default aggregation is by summation.This has to be changed to "Count" for information that does not require summation.

A List Consists of the Following Columns: Customer Id,customer Income,total