Hello,
I have a question on how analysis to generate to remove SKUs for this customer data
Solved! Go to Solution.
Hi @3D_Journey ,
Here are some hints
Step-1 - use summarize tool to grouby SKU
Take sum of sales, sum of units, count of orders (any column can we selected on columns)
Step-2 - on the previous output run a if-else formula to categorize ABC
Step-3 - sort by Category and total sales descending
Step-4 - use sample tool to get the first n%
I think that should solve the task.
Without data or sample data can't help much
Hope this helps : )
Thanks, can I email you this data instead?
I sent you the data if you can take a look at it, Thanks
Please did you received my email?
Hi @3D_Journey ,
Here is a workflow for the task with explanation.
Feel free to reach out me for more clarification.
Hope this helps : )
And all the best : )
It was a fun and interesting Use Case @3D_Journey
Hi @3D_Journey Try this. Its a packaged workbook.
If you run into any error please share the snapshots.