Cross Matrix

[Tommy23]

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!

[suby]

Hi Tommy,

Please find the attached to WF.

Thanks.

[NexBK]

Hi, @Tommy23 

I solved this question with Macro.

Connect the City list to this macro and set it up.

I hope you get the result you want.
I attach the yxzp file (package file).

[Qiu]

@Tommy23 
I managed to do it by a Macro.

[Qiu]

@NexBK 
I think we are the similar approach 😁

[Tommy23]

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]

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