How to subtract different tables and group by to create a bar chart

[SelflearningBi]

I would like to show this bar chart, is it possible to show it since I have two tables

 
I have two tables, and one table i group by as following: 

and I got this bar chart but I also need to include the ON TIME. 

I need the ON TIME column which contains in my master table which I group by as following tbale and I need to use the confirmed quantity to subtract the sum of APP Impact quantity to the ON TIME column of Apparel. 

APP: confirmed quantity - (sum of total impact impact of APP)

[v-jayw-msft · Accepted solution]

Hi @SelflearningBi ,

Please add a column to second table like below:

delay week = "On Time"

Then union two tables:

table3 = UNION('Table1','Table2')

Best Regards,

Jay