I have a customer that would like a sales report formatted as follows. Product Lines as the columns and sales territories as the rows. The tricky part is they want to group the Product Lines by Manufacture and provide a column with the Manufacture totals per sales territory. I have provided a simple example below. What I can't figure out how to match the current BASIC report that provides this information. This report can list approximately five Product Lines per page. If there are six a second page is used and for the sixth and totals column. Then the report continues the process for the next manufacture. Any suggestions would be greatly appreciated. I'm really stuck here.

Product_Line_1 Product_Line_2 Product_Line_3 Product_Line_4 Product_Total

Territory1
Territory2
Territory3
Territory4
Territory5


Jeff