I have data that needs to be grouped by state, customer, and items purchased. I want a total # and dollar $ of items purchased per state. Here is example of what I would like for it to look like:

                            # purchased    $ Amt
    OH
      Jones, John
               Item A        5            $100
               Item B        2              30
      Smith, Roger
               Item A        4             $80
               Item B        1              15
----------------------------------------------------
TOTALS:   Item A        9            $180
               Item B        3             $45
----------------------------------------------------
Then next state would begin.

For some reason, I can't seem to figure out how to get the totals. I can get a grand total # of items and $'s but can't get the breakdown to show at end of 'State' group. Any help is much appreciated.

Hi