Assume you are a sales manager who is planning a new sales campaign. Your company produces personal computer accessories. Several items are available, each ranging in price from the economy model to the deluxe model.
You want to know which customers are most likely to order this year's deluxe diskette holder, which you hope will make last year's model obsolete. You will send color brochures advertising the latest deluxe diskette holder to all customers who seem to order your most expensive items.
You also want to know which customers order less expensive items. You will send them the new color brochure that advertises the entire product line. In addition, you want to know which items a particular customer likes, and how large the orders are, so you can make decisions about letters to go along with your brochures.
You want a report that shows total orders for each customer, along with the average price per order. You will use the report to plan your sales campaign and to supply data for a letter to each customer. The data you need is in the CAI-DETAIL-TBL table.
|
Copyright © 2014 CA.
All rights reserved.
|
|