Sounds like you want to do a market basket analysis
if you are on 2018.3 you can use set actions to do that
you can reverse engineer the attached
you just create a set on the
you create a set on the lower level (sub cat)
then create a set on that set
and add a set action to the worksheet
it returns this
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
jim market basket.twbx 2.4 MB
Thank you for the return.
But actually what I need this...
I have the television item that had 30 orders, of these three I
would like the quantity of orders that came with an additional item to come to me, but I do not know what item it is, the tableau that has to make the account identifying the first, second and third item that most came out along with the first.
In the table below shows 30 orders with television, 30, 28 contained Desktops, 22 with servers and 19 Notebooks.
Soon I know that every time I sell a television I can offer one of three items as a complement.
Thanks for the help, but still not clear the information.
In the table below for example, the data is exactly as it is in my database.
I just want him to bring along with each item what else was sold with it, I'll send the file together for you to see.
That's all I need, in a tabulated form, it may even be conformed to this table below, which is actually the vision I have to do.
The table below shows the first, second, and third best-selling items, and the percentage of times the additional item was part of the key item.
They had 8 requests for television, of the 8 five had a desktop, so there are 63% of the television applications that have desktops.
Order Item 0423 Television 0423 Desktop 0424 Television 0425 Television 0425 Server 0426 Server 0427 Television 0427 Desktop 0428 Television 0428 Desktop 0428 Mouse 0429 Desktop 0429 Server 0430 Notebook 0431 Mouse 0431 Keypad 0432 Television 0432 Desktop 0433 Television 0433 Notebook 0434 Television 0434 Desktop 0435 Desktop 0435 Mouse 0436 Desktop 0436 Keypad 0437 Desktop 0437 Keypad 0438 Desktop 0438 Keypad