Creating Item Sold report using Pivot Table Sample1 pg 105 106

Creating 'Items Sold' Report Using The PivotTable Operation

Sample 1

	A				B			
2
3 	Sum of QTY
4 	ITEM SOLD		Total
5 	Model A			784,995
6 	Model B			810,061
7 	Model C			927,783
8 	NR				785
9 	Grand Total		2,523,624
10	

This report shows total quantity sold for each product item. To build this report, here are the steps:

1. Click any non-empty cell in the data area in the sheet DATA. (Make sure the data is not filtered).

2. Click menu Data/PivotTable and PivotChart Report.

3. A dialog titled PivotTable and PivotChart wizard Step 1 of 3 will appear.

4. Under the Where is the data that you want to analyze label, select Microsoft Excel list or database.

5. Under the What kind of report do you want to make label, select Pivot Table.

6. Click Next.

7. A dialog titled PivotTable and PivotChart wizard Step 2 of 3 will appear.

8. Excel will automatically identify the data area (or Range) and fill the box on the right of the Range label with the address of the data area. If your data structure follow the rules, the data area identified by Excel should be correct (but check the range anyway). If the range is incorrect, click Cancel, correct your data area and start again.

105

9. Click Next.

10. A dialog titled PivotTable and Pivot Chart Wizard Step 3 of 3 will appear

11. Under the Where do you want to put the PivotTable label, select few worksheet.

12. Click Layout button.

13. A dialog titled Pivot Table and PivotChart Wizard Layout will appear

14. Drag the button ITEM SOLD into the ROW box and drop it there. Drag the button QTY into DATA box and drop it there.

15. Click OK.

16. You will return to the previous dialog (Step 3 of 3).

17. In this previous dialog, click Finish.

You should see a report as above.




106