Cross Selling Pivot Table

[danimarc12]

Hello everyone!

I have a big issue with a pivot table in qlik sense. I want to display the following result I've created in Excel (the second table):

Basically I want to calculate in % how many times I sell in my order (scontrino) a product (reparto) with another one.

In this example, I sold 16 times BARBERIA . In the order 133879 I sold BARBERIA and HAIR CARE, so my expected value is:

1 time I sold HAIR CARE / 16 times I sold BARBERIA  ➔  1/16 = 6.25%.

2 times I sold LINEA BAGNO / 16 times I sold BARBERIA ➔ 2/16 = 12.50%.

3 times I sold PROFUMI / 16 times I sold BARBERIA ➔ 3/16 = 18.75%.

I guess I need to duplicate reparto because I cannot use the same dimension in the raws and in the columns of a pivot table.

My question is, how can I display this output? Which expression I need to write? Can anyone tell me all the steps I need to do to reach my goal?

Thank you very much to anyone who will help me 🙏