I have a table vith product code and sold quantity. In a second table I have for some product code (not all) an association with other product codes used for comparation.
I want to build a pivot table with two colums for each product code, in the first I show the total sold for the code in the second the mean (if exist) of all comparable product code. I would want to do it with set analisys but I was unable to think/find a solution
