Chapter 51. Creating subtotals
Questions answered in this chapter:
Is there an easy way to set up a worksheet to calculate the total revenue and units sold by region?
Can I also obtain a breakdown by salesperson of the sales in each region?
Joolas is a small company that manufactures makeup. For each transaction, it tracks the name of the salesperson, the location of the transaction, the product sold, the units sold, and the revenue. The managers want answers to the questions above.
PivotTables can be used to slice and dice data in Microsoft Excel. ...
Get Microsoft Excel 2016 Data Analysis and Business Modeling now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
