If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Cumulative Unique Record Count
I am trying to write a query to count the number of unique SKUs that have
shipped, cumulatively for each week in a quarter. My data looks like: Week SKU Quantity 14 200 50 14 300 100 14 300 60 14 400 80 15 200 400 15 300 200 15 400 60 15 500 20 16 400 10 16 400 800 16 600 600 16 700 20 The output that I am looking for is: Week SKU Count 14 3 15 4 16 6 Where each sucessive week only adds the unique SKUs that shipped that week. Any help with this is greatly appreciated. Best Regards, Russell |
Thread Tools | |
Display Modes | |
|
|