Cross Table Concatenation

Version

Application Scenario

When you need to customize the background color of the summary column title, you can achieve the effect by concatenating two tables, as shown in the following figure.

Implementation Method

You can create two table components, customize background colors and names of the two table titles as needed, and concatenate the two table components by using Hover and Combine functions.

Applied Scope

The table concatenation only takes effect on cross tables.

Data Preparation

1. Log in to FineBI, click My Analysis, select a folder, and click New Subject.

2. Click Local Excel and Upload Data.

You can download the sample data: Cross Table Concatenation.xlsx

3. Click OK after the data is uploaded.

4. Click Save and Update and Exit and Preview. The data is created successfully.

Component Creation

A left table component is created to display the Sales and Cost data of products, and a right table component is created to display the summary column data of those data in the left table component.

1. Creating the Left Table

1. Click the Component tab in the lower left corner, as shown in the following figure.

2. Select Cross Table in Chart Type.

3. Drag the Product Level field in the to-be-analyzed area into Row Dimension, drag Indicator Name and Date into Column Dimension, and drag Sales and Cost into Indicator, as shown in the following figure.

4. Click the  button next to the Date field in Column Dimension and select Year-Month from the drop-down list, as shown in the following figure.

5. Choose Component Style > Summary Row/Column. Click the Row tab and uncheck Total Summary Row to hide it in the table. Click the Column tab and uncheck Total Summary Column to hide it in the table, as shown in the following figure.

6. Choose Component Style > Component Padding and set the inner padding of the right-side component to 0px, as shown in the following figure.

2. Creating the Right Table

1. Click the  button at the bottom of the analysis subject editing page.

2. Select Cross Table in Chart Type.

3. Drag the Product Level field in the to-be-analyzed area into Row Dimension, drag Indicator Name twice into Column Dimension, and drag Sales and Cost into Indicator, as shown in the following figure.

4. Click the  button next to the first Indicator Name in Column Dimension and click Customize Grouping from the drop-down list. In the Customize Grouping setting box, check Assign Ungrouped Value to at the bottom and enter Summarized Value for the Last Two Years into the text field, as shown in the following figure.

5. Choose Component Style > Summary Row/Column, click the Row tab, and uncheck Total Summary Row, as shown in the following figure.

6. Choose Component Style > Style and set Theme Color to orange to distinguish the right table from the left one, as shown in the following figure.

Concatenating Tables

1. Click the Add Dashboard button at the bottom of the analysis subject editing page.

2. Drag the two components into the dashboard on the Dashboard editing page.

3. Click the left table component (blue one), click the  button, and select Hover from the drop-down list, the right table likewise, as shown in the following figure.

4. Click the left table component, click the  button, select Order, and select Move to Top. You can also click the right table component, click the  icon, select Order, and select Move to Bottom, as shown in the following figure.

5. Adjust the sizes of the two table components and align the left table component with the right one vertically and horizontally, as shown in the following figure.

6. Click the left table component, click the  button, click the right table component, and click OK in the upper-right corner of the page to combine the two table components. For details, see Component Combination.

Effect Display

Note:

The concatenated cross table can not be displayed on mobile terminals currently.