Pivot Table Building another report based on same data area pg 243 244

Building Another Report Based On Same Data Area

If you want to create another report, you may get this dialog:

Microsoft Excel

Your new report will use less memory if you base it on your existing report [Book2]Sheet2!PivotTable3, which was created from the same source data. Do you want your new report to be based on the same data as your existing report?

If you click Yes, you will save memory and your workbook file will be smaller.

If you click No, the two reports will be separate.

	Yes		No

This message dialog appears after you click Next in the step 2 dialog in the PivotTable wizard. You will not get this message dialog when you build the first report. This message simply means that Excel has detected that you are working on the same data area for which a report already exists.

You are given the option of using the current report as a basis for your new report. If you use the current report, it means Excel will use the same underlying data in the new report. This will save memory and keep your Excel file smaller. This is the best choice (selecting Yes) in the dialog.

We can use a shortcut way to build a report. Click any cell in the data area which you want use as the base for your report. Click menu Data/PivotTable and PivotChart Report. The PivotTable and PivotChart Wizard box appears. Click Finish. You will be presented with a new sheet. In the new Step 1 of 3 dialog sheet you will have a few boxes. You will see boxes with the following instructions:

Drop Page Fields here.
Drop Row Fields here.
Drop Column Fields here.
Drop Data Items Here.

You also see dialog box containing buttons representing the column titles on the underlying data area. You can drag one button at a time into a box to form a scheme of your report (the same way you do in the Layout dialog). The Drop Data Items Here box should preferably be the last box you drag a button into. As soon as you drag a button into the Drag Data Items Here box, the report will be ready for you.