I am roughing up a despatch profile and need to figure out how many different products (SKUs) we send from each warehouse to each particular country. my raw data is set up in a single table. I have so far set up a query that groups my data table (AllData2) by Warehouse and then Delivery Country but count merely counts the number of lines for each country. How do I get a unique count of SKUs associated with each Delivery Country?
-
If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.
count unique SKUs from each warehouse
- Thread starter ajm
- Start date
xenou
MrExcel MVP
- Joined
- Mar 2, 2007
- Messages
- 16,836
- Office Version
- 2019
- Platform
- Windows
The gotcha on this is that if a particular sku/warehouse/country doesn't exist it's just not in the results. For instance if there were no shipments of Sku XYZ from warehouse #1 to Denmark, there's nothing in the list. Some people would like to see a zero there. I don't use Pivots enough to see at a glance if Micron's query is the same or not - anyway, just a heads up.
Last edited:
Upvote
0
Excel Facts
Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"
Similar threads
- Question
- Question
