Merged Table - Examples

Same Dimension, different Measure

The Merged Table uses the first dimension that appears in all child tables as the first column and combines the values from this column in the child tables into one column in the Merged Table. In the following example, the first column in both child tables shows the Salesperson’s name but each child table uses a different measure. When the 2 child tables are merged, the Salesperson’s name will be combined into one column, the first column in the table, and the 2 differing measures will then appear in their own columns.

Open

Same Dimension, Measures with the same name and different values

If child tables have the same dimension but contain measures that have the same name but different values when the tables are merged, each measure column will contain the name of the child table along with the measure name. In the following example, both measures have the same name but we can see different values - the name of each child table is shown in the column headings.

Open

Different Dimensions, different Measures

If the child tables contain different dimensions and measures, they will be displayed in separate columns in the Merged Table - in the order that the child tables were added. In the following example, our first child table contains the columns Sales Person and Number of Sales and the second child table contains the columns Staff Name and Time Spent. When these two tables are merged we can see that Sales Person and Number of Sales are displayed in the first two columns and Staff Name and Time Spent are displayed in the second two columns.

If the order of the child tables is changed in the Edit Chart screen, the columns in the Merged Table will also be changed.

Common Dimensions

When merging tables, the system will always try and find a dimension that is the same in the child tables in order to display this as the first column in the Merged Table. If one of the tables contains a dimension that appears before the ‘common’ dimension this will be displayed in the first column of the Merged Table. In the following example, our 2 child tables both contain the Store Name but one of our tables has Region information as it’s first column. When the tables are merged the Region column will appear before the common column ‘Store Name’.

Crosstab tables

When child crosstab tables are merged, they will be combined into one ‘merged’ crosstab table.

Merging Crosstabs with Standard tables

You will be able to merge a standard table with a crosstab table.

In the following example we’ve merged a Crosstab table with a standard table. Both tables contain the Store Name but they don’t have the same measures. When the tables are merged, the measure from the standard table is displayed before the measure from the Crosstab table.