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

Question

issue?
(1 point)
create a new Pivot Table
create a new filter
modify values
modify rows

Answer 1

To change the calculation from sum to average in a PivotTable, Charles should choose the option to modify values. This can usually be done by right-clicking the value field in the PivotTable, selecting "Value Field Settings," and then choosing "Average" from the list of calculation options.