I can easily achieve the same result with a pivot table by dragging the Salesperson field into Rows and the Sales field into ...

When you compile data in a list, you often need to answer questions such as “How much revenue did the West Coast office generate last month?” or “What was the average number of customers served at ...