One retailer sells items in different cities. The sales manager aims to analyze the number of sales in each city by each sales person to get a general understanding of the performance in sales.You are required to:

$1-$ Find the Summation of Sales in each Segment;

$2-$ Find the summation of Sales in each Segment in different Countries;

$3-$ Find the Count of Sales in each Category;

$4-$ Find the Summation of Profit in each Category and Sub$-$Category;

$5-$ Find the Summation of Sales of each Sub$-$Category filtered by Region;

$6-$ Insert a Pivot Chart to show the Summation of Profit of each Sub$-$Category;

$7-$ Insert Data Legend and Chart Title for the chart;

$8-$ Insert a Filter for the Chart to show the Summation of Profit of each Sub$-$Category in the East Region;

$9-$ Sort the Table based on the Ship Mode and Order ID;

$10-$ Use Conditional Formatting to show the loss in the Profit column with Red color;

$11-$ Change the Format of Sales Column to Currency;

$12-$ Freeze the first column;

$13-$ Insert a column to automatically write "Good performance" if the Sales are greater than $500$$;

$14-$ Start from Order ID $"$CA$-2014-105893",$ move $5$ rows up and $4$ columns right, return the outputBAW$5($Q$)$

Ready $"?$ Accessibility: Good to go