combining articles

[cscherer]

Hello,

I got a new problem: I have got orders and articles per order. My aim is to count, how many combinations of 2 articles I have got in the orders and how often the combination appears.

I have absolutely no idea how to start. Perhaps it is possible to solve this in a pivot-table?!

I would be delighted, if you have got any ideas or approaches to a solution.

I will add a picture to make my problem a bit more understandable, and a data file.

Thank you very much in advance,

Clemens

[swuehl · Accepted solution]

Maybe like attached (using a duplicate table linked by order)?

[#3]

hi,

Yes you can do this in front end.

use the chart aggreggation function CONCAT to find the combination of articles and then count the frequency of occurence by using aggr.

[cscherer]

this is it! incredibly fast!

thank you so much!!!

[cscherer]

thank you, i`ll try out your proposal