Is there a way to use the lookup function to find a particular row and column and not just a row in the same partition? I can easily do this with the offset function Excel where I can go over x column and down x rows
I want to add the green colors and the blue. So 100+61=161 for green and blue is 100+60+51=211. I want these in different columns as well.
Can you post an example of the finished table that you're looking for? It will make it easier to try and reproduce it in Tableau.