How do you create a relationship between two queries with same database

Question

I have some database view with several columns and among them there are these columns "item_type", "amount" and "quantity". There are 5 different values in column "item_type"

 I have created a pivot query and used "quantity" column to aggregate.

 Then I have created another pivot query and used "amount" column to aggregate.

Now I want to add a table including data coming from both queries, but I dont know how to create a relationship between the two queries as I was not able to find a column with unique values for both