Help Creating a Matrix

Question

Hello all!

I've run into an issue where I am trying to create a matrix to show the number of identifiers that end up in multiple different values in the same column. I have attached a workflow as an example of what I am trying to achieve.

Essentially its a count of IDs that have a record of value A and Value B

Let me know if you have any questions. Appreciate the help!

Seth

Item Matrix.yxmd

RSreeSurya · Answer

Hi,

If you can help with exact output (Format & Numbers) you are looking for, for my better understanding.

Will create a workflow accordingly.

Thanks

seth_fuller · Answer

Hoping to push this back up to the top of the forum in hopes to get an answer

seth_fuller · Answer

Appreciate the help. Thats not quite doing what I'm looking for.

I want to know of the potential combinations of Items (in this case Pizza, Burgers, Chicken Tenders, Fries) how many IDs crossed these. The output in the attached workflow is accurate to the numbers I'm trying to replicate.

So you'll see in the below, that there is 1 instance where an ID had Pizza multiple times

Input:

Output: