Analysis Data

[3D_Journey]

Hello,

I have a question on how analysis to generate to remove SKUs for this customer data

[atcodedog05]

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 : )

[3D_Journey]

Thanks, can I email you this data instead?

[3D_Journey]

I sent you the data if you can take a look at it, Thanks

[3D_Journey]

Please did you received my email?

[atcodedog05]

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 : )

[atcodedog05]

It was a fun and interesting Use Case @3D_Journey 

[atcodedog05]

Hi @3D_Journey  Try this. Its a packaged workbook.

If you run into any error please share the snapshots.