I can't figure out how to do this: where do I put the fields, and how do I filter through to find the top 10?
Pivot #1 (25 points)
• Create a pivot table in a new worksheet. Name the worksheet “Top 10 Customers”
• The pivot table should show the total sales (Document amount) for the invoice and order document
types only for the top 10 customers (by Customer Name) in descending order. It should also contain a
Grand Total column.
• Add the title “Top 10 Customers” to the pivot table.
• Change column/row 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 0 decimal places.
• Once the pivot table is created, insert a 3-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