doanh số bán hàng của từng sản phẩm theo tháng. Chọn đếm, ví dụ, sẽ đếm số lượng giao dịch cho mỗi sản phẩm trong mỗi tháng, chọn Max sẽ tính toán các giao dịch bán hàng lớn nhất cho mỗi sản phẩm trong mỗi tháng. Hộp Củng cố thoại cần được điền như trong hình 47-5. | 414 Microsoft Excel 2010 Data Analysis and Business Modeling sales of each product by month. Selecting Count for instance would count the number of transactions for each product during each month selecting Max would compute the largest sales transaction for each product during each month. The Consolidate dialog box should be filled out as shown in Figure 47-5. After clicking OK the new worksheet looks like the one shown in Figure 47-6. See file . You can see for example that 1 317 units of Product A were sold in February 597 units of Product F were sold in January and so on. FIGURE 47-5 Comp eted Conso date d a og box. 1 2 A B c 0 E 1 January February March 3 H 131 71 266 7 F 597 577 327 113 A 1323 1317 1445 24 B 890 335 812 30 c 1231 922 843 39 D 767 1424 1199 44 E 579 483 371 49 G 570 850 811 FIGURE 47-6 Tota sa es after conso daton. Now go to cell C2 of and change the February Product A sales from 263 to 363. Notice that in the consolidated worksheet the entry for February Product A sales has also increased by 100 from 1 317 to 1 417 . This change occurs because the Create Links To Source Data option was selected in the Consolidate dialog box. By the way if you click the 2 right below the workbook name in the consolidated worksheet you ll see how Excel grouped the data to perform the consolidation. The final result is contained in the file . Chapter 47 Consolidating Data 415 If you frequently download new data to your source workbooks in this case and it s a good idea to name the ranges including your data as a table. Then new data is automatically included in the consolidation. You might also choose to select some blank rows below the current data set. When you populate the blank rows with new data Excel picks up the new data when it performs the consolidation. A third choice is to make each data range a dynamic range see Chapter 22 The OFFSET Function for more information . .
