Forum Discussion
Helper IICalculate between displayed tables
Super UserHi MyWeeLola ,
What is the problem, I apologize for missintreperting the question. Can you please elaborate on what is the question at hand.
To what I can understand you want to have the calculation based on the weighted values, and the solution I gave you does that calculation.
Is there any issue with the unpivot of the tables? What is not matching your needs?
I see that the last values are not macthing the result you shared but I believe is because I copied the information incorrectly for line 10.
I have also unmarked the answer to be correct since you refer that is not the solution (other user on the community can accept answers and probably that is what happened).
Helper II
Thank you for the response. You were the closest, however I could not get your solution to work.
The final solution involved a variation of what you put down which used a filter on the table and using ==. I had to go to an external resource to purchase the solution. However if I had more time with your solution I suspect we would have got there.
Given that here are similatrities in your solution, ill mark it as the solution.
Have a good day
Lola