The result shown figure chapter pivot tables and pivot chartsfigure

Chapter 3 ■ pivot tables and pivot Charts

3. At this point, you have to think through what type of data you want to extract. We will start with a summary of sales per day, with a breakout of models sold per day. We will do this by dragging sell date to the Columns box, model to Rows, and price to Values, as shown in Figure 3-5. Note that the default display is Sum of price.

Chapter 3 ■ pivot tables and pivot Charts

Figure 3-7. Pivot Table showing sales by model and salesperson

39