Tatertot45
Technical User
- Jun 11, 2007
- 161
I'm using CR XI, SQL server DB and XI is a stand alone, not in BO.
I haev a sales person that wants to analyze what the customers have purchased in the initial launch, and what they have re-ordered. We don't mark this in the DB anywhere, so i need to create it. I was thining that i could use the minimum Inv date in a group. The group was going to based on Customer number. Afer i get the initial order, i also need to sum the "non-minimum" orders, which will be considered re-orders. anyone have any suggestions? I'm summing Sales (which is created witha formula).
I haev a sales person that wants to analyze what the customers have purchased in the initial launch, and what they have re-ordered. We don't mark this in the DB anywhere, so i need to create it. I was thining that i could use the minimum Inv date in a group. The group was going to based on Customer number. Afer i get the initial order, i also need to sum the "non-minimum" orders, which will be considered re-orders. anyone have any suggestions? I'm summing Sales (which is created witha formula).