$$Excel format please

Enable Editing

You are the Financial Analyst at Fresh Fruits & Vegetables, a global distributor of high quality organic foods. You got the data on the previous worksheet from the Sales Department. $($I have already created a named range called "order" which includes the entire dataset if that helps.$)$

A $-$ A$.$ Find the Total Quantity, Total Cost and Total Revenue of each product by country and Quarter. Format all dollar values to currency with $2$ decimal places $($that is $$94,689\mathrm{.}00).$ Quantity should be in "comma" format with no decimal place. $($i$.$e $44,910)$

B $-$ Create a Calculated Field called Total Profits, where Total Profits $=$ TR $-$ TC$.$ Now add this as a column in your pivot table.

C$-$ Calculate the percentage contribution to the total profits for each country. Hint: Use the command for $"\%$ of Column Total" under the "Show Values as$"$ Tab under the "Value Field Settings". Call this column "Contrib to Profits". Format your numbers as percentages with $2$ decimal place $($i$.$e $12\mathrm{.}12\%).$

D $-$ Create a calculated field called "Per Unit Profit". Where Per Unit Profit $=$ Profit$/$Quantity$.$ Format your numbers as currency with $2$ decimal place $($i$.$e $$39\mathrm{.}19).$ Now add this as a column in your Pivot Table.