Hi there,
I'm trying to generate a file that helps me figure out how many widgets were in the field as a function of days since deployment. Here's an example:
[Days since shipment] [Running Total]
1 / 234
2 / 230
3 / 220
4
5
6 / 210
Nothing shipped 4 days ago or 5 days ago, for example. But the number of widgets in the field for days 4 and 5 will be identical to 6, so I need a way to push "210" into those particular records. There are hundreds of records like this and the units shipped "x" days ago will will increment with each passing day.
I mucked around with DFirst, DMin, etc., but I couldn't ever get it to work correctly.
I'm trying to generate a file that helps me figure out how many widgets were in the field as a function of days since deployment. Here's an example:
[Days since shipment] [Running Total]
1 / 234
2 / 230
3 / 220
4
5
6 / 210
Nothing shipped 4 days ago or 5 days ago, for example. But the number of widgets in the field for days 4 and 5 will be identical to 6, so I need a way to push "210" into those particular records. There are hundreds of records like this and the units shipped "x" days ago will will increment with each passing day.
I mucked around with DFirst, DMin, etc., but I couldn't ever get it to work correctly.
