How to perform table consolidation in WPS tables

"Consolidation" is a summary tool that the WPS table provides to users to implement multiple table data statistics. The consolidation tool enables users to implement data rollup in multiple tables based on the specified single-column (or single-line) data condition. When you make a consolidation, you must specify the target area where the rollup results are held, which can be on the same worksheet as the source data or in other worksheets or workbooks. Second, the data source that needs to be selected for consolidation can come from a single worksheet, multiple worksheets, or a different workbook.

There are two sales subsidiaries in an enterprise, and when the head office wants to get total sales of each product, you can use the "consolidate" feature to summarize the data. The following is the first quarter of Dafa Company's monthly sales situation as an example, in this case will be Shanghai, Guangzhou, two branches of the worksheet is summarized, the results are saved in the head office of the worksheet.

Open work Book

Use the WPS table to open the workbook file as shown in Figure 1.

Figure 1 Source Workbook file

To locate the target area:

First use the mouse to navigate to the A2 cell of the Head Office worksheet, select the Data | Consolidation menu item, and in the function Drop-down box of the Merge Calculation dialog box, select the summary function to consolidate the data, as in this example using the SUM function for summarizing. As shown in Figure 2.

Figure 2 Setting up a summary category

Add Detail Area

In the Reference Location box, enter the definition of the source area where you want the consolidation to be calculated.

Step 1 position the cursor to the reference location text box, select the "Shanghai" Branch Datasheet tab and choose the A2:d5 area.

Step 2-Click the Add button on the right to add the Guangzhou data area to the list box in all references locations.

Step 3 Repeat steps 1 and 2 to add the data table area of the Guangzhou branch. Step 4, under Label position, select the check box for first row and leftmost column, and the results are shown in Figure 3.

Fig. 3 Selection of the destination area

Complete summary

Press the OK button. You can see the results of the merge calculation, as shown in Figure 4.

Figure 4 Results of the classification consolidation

Summary:

1. Users can use "consolidation" to summarize multiple tables.

2. If the user wants to summarize by the first row of the source range, you need to tick the first row check box under heading position.

3. If the user wants to summarize by the left column category mark in the source range, you need to check the leftmost column checkbox under heading location.

4. In the WPS table, you can specify up to 255 source areas for consolidation. When you consolidate, you do not need to open the workbook that contains the source range.

Scope of application:

Applies to WPS Office 2005 and above.