Would you like to know by consumer what have they bought or a series of products how did they perform?
I think I can help you.
so basically by selecting a "product id", I would like to find a group of users who have purchased that product along with other products they have purchased. Then show the list of products in number of counts.
You can use the Workbook created, basically you would need to use Fixed LOD to get the desired result.
you can download the workbook from below link.
Right, so you have 2 questions and 1 dataset.
I think the way to go would be to ask the first one on one sheet and the second one with the info of the first on a second set.
Attached you'll find a dashboard that does that using the first 500 rows or so of your dataset.
Below is explained the logic of the dashboard
Is it something like this?
select a product, and the user who bought this product will be displayed along with # of total products the user bought as bar
A workbook attached for your reference.
Hope this helps
Book1_v10.2.twbx 6.8 MB
Nope. This is not what i wanted but I do appreciate your help.
What i need is select a product(lets say P0009842) then show all purchased products(in count) of users who have purchased P0009842.
A questions though, why use set instead of filtering Product ID directly? What difference would that make?
Sorry that I have confused you.
Actually its one question. Select a product(lets say P0009842) then show all purchased products(in count) of users who have purchased P0009842.
There are 2 questions there, have you tried using the approach I mentioned before (attached here again).
Otherwise from the data source you can check all the permutations that will happen with each product you select, however that would turn into a lengthy database.
Thanks Alejandro. Yes I have checked it but that basically means I have to filled the data in twice, once to select the product and find out which user bought it, secondly to select the users who bought them to find out the counts of the product.
Is there a way we can avoid the second part of selecting the users and show directly how many products where bought?
No, unfortunately I've been in similar situations.
What I did is the number of permutations in the database to make it work.
For example in column A i put the product bought say ALPHA and then in column B i Placed the clients who purchased Alpha, assume there are 2.
After that I manually checked the 2 clients and added their other products purchased in column C.
That way when in column A you select alpha, in column C you will have all the other products that were purchased.
Seeing the size of your database that would be a lot of permutations, consider using VBA or Python if you want to develop such analysis.
If you find any of my answers helpful please mark them as 'they helped me' or 'solved' since that give me points.
As per my understanding, I tried achieving your requirement.
I have sample superstore data set, considered product id which are referring above as product name
and users as customer name.
So what i understood was when even you select product name, you should get who are the customers brought that product id as well as count of what other products they bought along with the selected one.
Please find below screenshot for reference and workbook in the attachment.
Please mark this as answered if this is the solution you are looking for.
sample.twbx 1.2 MB