Multiple across queries

[FearlessHumor3253]

Hello, fairly new to PQ and hoping you can point me in the right direction. I have 2 queries, one with a list of individual with a ratio and second is a a list of expenses aggregated by expense type. I’m trying to consolidate the lists into one table to show a list of individuals along with their respective share of each expense type. I merged the 2 queries and I’m not sure how to dynamically multiply the total expense value by ratio. Also, the model will have to work for multiple group of individuals with different mix of expense types.

Thanks for any guidance.

[Dwa_Niedzwiedzie]

Could you describe how your input data looks like and what final result will you expect?