GROUP TOTALS

[SIMON]

I am trying to find how to get a group count to count only one per customer. Ex. Same customer buys items from several categories. Sort by category and totals for each category but if the customer is in the first category not to be included again in next xategory even though he bought items from second category. Any help would be appreciated.

[kfleming]

Unless you want to sort by customer, there is no an easy way to get this total.____Kathleen__R&R Support

[SIMON]

If I sort by customer and group by category then every category will __display within each customer. Am I correct or not getting something properly.

[kfleming]

You are correct that it can only be one way or the other.__One way to get this to work is to create two reports. The first report sorts/groups by customer and generates a summary total.__You then export this total to either a text file or a DBF.__The second report is the product sort with the customer total from the text or DBF added to this report as an inserted text file or a lookup related table.____Kathleen__R&R Support