Cross Matrix

Question

Hello

I have receives this transaction for each customer and cities.

I want to create a matrix which displays the total number of nights spend in each city in relation to the other cities also purchase by that customer.

I send you the Input data and the output data. I try to use cross tab and also MB_Affinity but without success. Can you please help me.

Thanks in advance for your answer, best regards!

Input.xlsx

Output.xlsx

Qiu · Answer

@Tommy23 
I downloaded my workflow package and it works just fine.
let me upload them again.

0808-Tommy23.yxmd

Tommy23.yxmc

Tommy23 · Answer

Hello, @NexBK @Qiu

I can not open the macros, an error happen "" The entry point is invalid"

Usually this happens when workflow is not completely packaged. Macros should be selected (highlighted are macro which needs to be checked) while saving it as packaged workflow.

Can you please upload a new file thanks in advance

Qiu · Answer

@NexBK 
I think we are the similar approach 😁