Calculate Count of item combinations occurance

[Anonymous]

Hi folks,

I have a bit tricky task here, hopefully someone will be able to help out!

My data looks like this:

And I need to get a visual which will show how many orders have certain items combination ordered together.

In this example, Items def and pnl are presented in two orders (A12 and B32), which is 25% of all orders.

Or Items abc and pnl are presented in three orders (A12, R83 and U34), which is 37.5% of all orders.

How to calculate that?

Ultimately, I'd like to build a dashboard like this:

Solution with Python scripting will work for me as well.

Sample data can be found by the link (a spreadsheet on google drive)

Thank you!

[Anonymous]

Thank you all for the great suggestions!

@ThxAlotAt this point I will not pretend I fully understand what you are doing there, but looks like that is exactly what I need! Will try to apply it to my real data.

Thank you!

[ThxAlot · Accepted solution]

[Ashish_Mathur]

Hi,

See if this file helps.

[VahidDM]

Hey   

Check this file:

https://easyupload.io/gf0hxa

The Output:

If this post helps, please consider accepting it as the solution to help the other members find it more quickly.

Appreciate your Kudos!! 

[Jaed]

Would you be so kin do share you file with me?