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