How to create a frequency matrix of order complexity

[#1]

Hi there,

I need some help with the following...

I want to create a frequency matrix that shows me the frequency of materials and shipping points used in an order.
By this report I want to meassure the complexity of orders.

The more shipping points and the more materials used in one order, the more complex the order is.

I have added a table (excel) with the orders data.

From this table I want to generate a matrix as showed below

Can anyone help me to build this matrix in QlikView?

Regards,

Cor

[Gysbert_Wassenaar · Accepted solution]

See attached qvw.

[#3]

Hi Gysbert,

This did worked out perfectly.

Thanks for you help

Regards,

Cor