Creating Items Purchased report using PivotTable sample 1 pg 98

Creating 'Items Purchased Report Using The PivotTable Operation

Sample 1

	A					B
1
2
3 	Sum of QTY
4 	ITEM PURCHASED		Total
5 	Gum X				190
6 	gum z				235
7 	NR					2,522,839
8 	Pencil 2A			180
9 	Pencil 28			180
10 	Grand Total			2,523,624

The report shows the total quantity of each item purchased. To produce the above 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 the 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 PivotTable.

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 fills 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.

98

9. Click Next to go to next step.

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

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

12. Click Layout button.

13. A dialog titled PivotTable and PivotChart Wizard Layout will appear.

14. Drag the button ITEM PURCHASED into the ROW box and drop it there. Drag the button QTY into the 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 be presented with a items purchased report in a new sheet (as we can see above).

99