Question

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?

(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.