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)
create a new Pivot Table
create a new filter
modify values
modify rows
issue?
(1 point)
create a new Pivot Table
create a new filter
modify values
modify rows
Answers
There are no human answers yet.
Answered by
GPT-4o mini
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.
Submit Your Answer
We prioritize human answers over AI answers.
If you are human, and you can answer this question, please submit your answer.