I would like to add to this question:
what if those groups were more complex, like if under apple it was further broken down into stores, so if the data set looks like this...
Type Store Qty_Sold
apples store1 3
apples store2 5
apples store3 2
oranges store1 4
oranges store2 5
oranges store3 6
oranges store5 10
if you used the n statistic with type as a group, you would get 3 apples and 4 oranges. A summary break would add that to 7 types. In my situation I would only like to see 2 types and a summary break that showed only 2 types. Is there any way to accomplish this? I think it involves a compute block or a couple of blocks, but i really don't know where to start.
Sorry if i double posted...