In Excel the Pivot Table Wizard involved four steps instead of threeThe former third step dragging fields onto the Layout dialogwas moved to the Layout button in the final step of the Pivot Table Wizard

After a Pivot Table has been created on your worksheet, you may easily change the data summarized in the report by dragging fields from the Pivot Table Field list and dropping them on the appropriate section of the pivot table. In Figure 12.5, Customer was added to the Row area of the existing pivot table.

Figure 12.5

The name "pivot table" comes from the ability you have to drag or drop new fields on the table and have them recalculate.^ a couple of clicks, you can move Region across the top,move Product down the side, and add a summary by Customer.

0 0

Post a comment