Crossed sales

[Adrian1]

Hi,

I'm trying to know, with a set analysis calculation, the next:

When the user select a Product, show a table with the detail of products that has been solded in the same Order than the product I have been selected, and the number of coincidences (number of orders).

Is it possible to do with set analysis?

[StarinieriG]

Hi,

try with something like this:

sum({<order={'$(=Max(order))'},product=>}1)

[Adrian1 · Accepted solution]

with Product as Dimension:

count( DISTINCT {1< OrderId=P( {$} OrderId) >} OrderId)