Here's the info Pivot Table Configuration To complete my basic sales analysis pivot table, I need to add Select an answer Average of Quantity Sold Sum of Quantity Sold Count of Quantity Sold Max of Quantity Sold to the Values area. This will calculate the total units sold for each product and category. Pivot Table Output After configuring the pivot table, I can see that the Apple OptiPlex i5 32GB RAM has sold Select an answer 150 203 100 107 units, according to our data