Kyla has a Clustered Column PivotChart that compares sales in four locations.How can she add columns that show a 10 percent increase in sales in each location?
A) Add a calculated field.
B) Switch columns and rows.
C) Filter the PivotChart.
D) Refresh the data.

Question

Quizplus · Accepted Answer

To add a column that shows a 10 percent increase in sales in each location, Kyla should add a calculated field. This calculated field can be created by selecting the PivotTable Analyze tab, clicking on Fields, Items & Sets, and selecting Calculated Field. From there, she can create a formula that calculates the increase in sales and add it as a column to the PivotChart.

Kyla Has a Clustered Column PivotChart That Compares Sales in Four