Layout of the Spreadsheet - Riverside City College

From the menu: Wizard [Excel 2003 = Pivot Table Wizard] - Layout. The COLUMN-ROW-DATA box re-appears. Drag and drop PRODGROUP anywhere outside the ROW area. Drop ACCNO into the ROW area. Then drop CUSTNAME below ACCNO in the ROW area. Then: OK - Finish. The pivot table now displays sales by Customer account number and name. ................
................