This can easily be done with script. However, I don't understand the structure of your tables or where you want the cross product data to show up.

Nevertheless, here is some sample code that will create the cross product of two arrays

**["T1", "T2", "T3"] ****_** **["E1", "E2"]**function crossProductOf() {

return _.reduce(arguments, function(a, b) {

return _.flatten(_.map(a, function(x) {

return _.map(b, function(y) {

return x.concat([y]);

});

}), true);

}, [ [] ]);

};

var array1 = ["T1", "T2", "T3"];

var array2 = ["E1", "E2"];

var crossProduct = crossProductOf(array1, array2);

console.log(JSON.stringify(crossProduct, null, " "));

output:

[

["T1","E1"],

["T1","E2"],

["T2","E1"],

["T2","E2"],

["T3","E1"],

["T3","E2"]

]

To implement this you need to use script to obtain the data for each array using

**API_DoQuery **and then call the above code and either pump the cross product into a table or spit out the results as HTML.

**MATH TRIVIA:** Did you know that the

**cross product** or

**Cartesian product **is named after the famous mathematician

**Ren� Descarte?**