Question: Create a pivot table in a new worksheet. Name the worksheet Top 1 0 Customers The pivot table should show the total sales ( Document
Create a pivot table in a new worksheet. Name the worksheet Top Customers
The pivot table should show the total sales Document amount for the invoice and order document
types only for the top customers by Customer Name in descending order. It should also contain a
Grand Total column.
Add the title Top Customers to the pivot table.
Change columnrow headings on the pivot table to accurately describe the data that is being
displayed.
Use appropriate and professional formatting on title, currency and heading cells. Currency cells should
have decimal places.
Once the pivot table is created, insert a D stacked Column Pivot Chart based on the pivot table. The
graph should show the customer on the bottom axis and should be on the same worksheet as the pivot table so that both the pivot and graph can be seen at the same time.
o Add an appropriate title and legend to the chart o Show data labels as callouts on the chart
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
