Help with Sum formula in 2 different Queries

[raq3]

Hi everyone, 

I have been trying to create a Labor Tracking Rates dashboard with the information below.

• Estimated Hours (Query 1)
• Burned Hours (Query 1)
• Project Name (Query 1 and Query 2)
• Cost Code (Query 1 and Query 2)
• Project Description (Query 1 and Query 2)
• Install Quantity (Query 2)

My challenge has been to create a table where the install quantity column reflects the quantity by the job. However, I tried to create different relationships but none of them worked. The only one that worked partially was the Project Description> Project Description. Yet, the table shows the overall total install quantity and not by description and by job as you can see here.

 I also tried to change the data type and merge queries, but it did not work.

Does anybody know how to fix it?

Thank you

[raq3]

@Ashish_Mathur these are the results I expect to see in one of the jobs.

[Ashish_Mathur]

Hi,

Without getting access to the file, I will not be able to to help you.

[Ashish_Mathur]

Hi,

Without getting access to the file, I will not be able to to help you.

[Ashish_Mathur]

Hi,

Share some data and show the expected result.