So, I have a straight table with a hidden column that can be shown just by clicking a button.
My problem is: is there a way to continue using the values of that column when she is hidden? Because I'm using column(1) when she is being shown so I can use her values, but when I hide her, the column(1) changes to another column.
When I select Prod1, the table shows all other products, how many areas they have in common and the avg(sales).
But when the column Area is hidden, the avg is being calculate wrong, I don't know why but as my example shows, Prod2 has 9 Areas in common with Prod1 and the avg for Prod2 isn't 62 as my table shows, if you guys see the table with the column Area being shown, calculating by hand the avg of all 9 areas is 54, and 62.
So, I need to calculate correctly when the column is being hidden, so I need to get all 9 areas that are in common, get all avg of those 9 areas separately and calculate the avg, which should be 54.
I hope with the example things get more clear now, and thanks again everyone who is trying to help.
