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

modify values

Right-click the value field in the PivotTable (or click the field dropdown) → Value Field Settings → choose "Average" instead of "Sum".