Displaying Totals for Each Category with Two separate tables

[holydragon]

Hello,

I have two tables that have a common department number

Table 1                            Table 2

Dept.  Total                     Dept.  Total

A         1                           A        3

B         2                           C        5

C         3

Table 2 does not have all of the departments shown in Table 1.

What I would like to do is show a bar chart of the with the values to table 1 and table 2 side by side

Chart

1 3          3 5

A             B

however, whenever I link the tables together  I get the correct value for Table 1 but the total for table 2

Linked Table

        1              2

A     1              8

B     2              8

C     3              8

How do I reflect the right totals for Table 2?

I am expecting something like:

        1              2

A     1             3

B     2             

C     3              5

Any help is appreciated!

HD

[v-yuta-msft · Accepted solution]

Hi holydragon,

You may merge table1 and table2 first, click query editor-> merge.

 

 

Then delete Table2.Dept. , the result is like below:

 

Regards,

Jimmy Tao