Cross Matrix
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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!
- Labels:
- Custom Tools
- Data Investigation
- Output
- Workflow
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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).
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Tommy23
I managed to do it by a Macro.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@NexBK
I think we are the similar approach 😁
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
@Tommy23
I downloaded my workflow package and it works just fine.
let me upload them again.