Let's say we wanted to answer the question What is the amount sold by each of 20 salespersons? Answering it could be time-consuming and difficult; each salesperson appears on multiple rows, and we would need to total all of their different orders individually. Explain how a pivot table could be used in carrying out this task, along with how you would format the ending report.