Part $1$

In a new Sheet, create a PivotTable that shows the average Order Amount by Customer. Plot the results in a Pivot Chart. Format the values as Curency.

Part $2$

In a new Sheet, create a PivotTable that shows the total Order Amount for each Salesperson by quarters $($every $3$ months$).$

Plot the results in a Pivot Chart. Place both criterias in the Rows area.

Note: Rename the sheets as you see appropriate

Part $3$

In the sheet in Part $2,$ add a trendline to the PivotChart and answer the following:

In $2017,$ What can you conclude from the chart with the trendline?