Charles created a PivotTable to compare sales and return on sales. He wanted to choose average instead of sum. How can he fix this issue?

Question

(1 point)
Responses

create a new Pivot Table
create a new Pivot Table

create a new filter
create a new filter

modify values
modify values

modify rows
modify rows

Answer 1

To change the aggregation method from sum to average in a PivotTable, Charles should select the option to modify values. This typically involves clicking on the value field in the PivotTable and then selecting "Value Field Settings" where he can choose "Average" as the calculation method.