Forum Discussion

Torudd-55's avatar
Torudd-55
Frequent Visitor
6 years ago
Solved

Matrix

Hi everyone reading this post!

 

I need help with creating a matrix with a calculated value in each cell.

What i want to achieve is to recognize the number of sales a kombination of two different items have together.

 

As an example, the table could be looking as below:

 

Orderno   item.no

112
 13
 14
213
 3
33
 13
 14
 15
414
 15
513
 3
612
 13
713
 14
 3

 

And the result of the measure i would like to get from this table is as below, the bold numbers:

 

item.no

     
312131415
300421
1200210
1342031
1421302
1510120

 

Thanks in advance!

 

2 Replies