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
How to calculate loan payments in Excel?
Use the PMT function: =PMT(5%/12,60,-25000) is for a $25,000 loan, 5% annual interest, 60 month loan.
Similar threads
- Solved
- Question
- Question
