I am trying to determine the additional sales someone makes within 10 days of their main purchase. Here is a link to a sample spreadsheet. In this spreadsheet you will find a sales table (within the PowerPivot model you will also find a calendar table).
In this example a Bike purchase is considered the main purchase and I want to know how much they bought with in the next 10 days. So the correct outcome would be:
Customer ID 5: $50 because they bought a bike on 1/5/2017 and then on 1/10/2017 they bought a seat for $50. They also bought pedals on 2/15/2017, but that is more than 10 days pasted their bike sale so it is not counted.
Customer ID 7: $15 because they bought a bike on 1/7/2017 and then bought a $5 bell on 1/9/2017. They bought another bike on 3/1/2017 and on that same day bought a basket for $10, thus $10 plus $5 is $15.
In this example a Bike purchase is considered the main purchase and I want to know how much they bought with in the next 10 days. So the correct outcome would be:
Customer ID 5: $50 because they bought a bike on 1/5/2017 and then on 1/10/2017 they bought a seat for $50. They also bought pedals on 2/15/2017, but that is more than 10 days pasted their bike sale so it is not counted.
Customer ID 7: $15 because they bought a bike on 1/7/2017 and then bought a $5 bell on 1/9/2017. They bought another bike on 3/1/2017 and on that same day bought a basket for $10, thus $10 plus $5 is $15.
Last edited: