We need a workbook, This looks interesting though.
Thank you for your response.
I'm going to insert a new picture and that's how it looks to me in Tableau. Unfortunately, I should cover a lot, so that the data is not visible.
So it works following mass:
You select an ID from the filter at the top left for tabele 1 and as soon as an ID is selected you will see the values for X and Y, as well as the sum of them. As soon as you select another ID, other values come out.
You should manually insert the results of the sum into the parameter below, since I need the ones in Table 2 for the subtraction.
So the question is:
How or what should I do so that the parameters in Table 1 do not have to be entered manually, but are automatically transferred after the calculation of SUM X and Y?
Is there perhaps another way for the problem without parameters?