I have a sales report that lists departments, sales people, product categories and number of sales for the last 7 days and last 30 days. The report looks like this and works great: Last 7 Last 30 Department 1 SalesPerson1 ProductCategory 1 5 25 ProductCategory 2 5 25 SalesPerson2 ProductCategory 1 2 10 ProductCategory 2 7 15 Now, I would like to display a summary for each department like this: Last 7 Last 30 Department 1 ProductCategory 1 7 35 ProductCategory 2 12 40 SalesPerson1 ProductCategory 1 5 25 ProductCategory 2 5 25 SalesPerson2 ProductCategory 1 2 10 ProductCategory 2 7 15 How can this be done? I have inserted a group below the Department-group and it displays as desired whn the salesperson-group is not expanded, but when I expand it all salespersons are displayed once for each product category. It seems like the salespersons-group is inside the new "department summary group" but I want it ajasent, if possible. Lumbago www.thefirstsql.com

Hi LUmbago, If you are after the sum of product category @ Dept level, then insert a row after the Department group (but within that group). Then add Product Category column and add Sum forumula next to it. Hope that helps. Good luck, regards Natraj www.BItipsntricks.com Mark as Answer, if it is answer for your Question. Vote as Helpful, if it is helpful to you.

I'm not sure I follow. As you can see from my example I have several product categories that I want to sum per department, and if I insert a new line inside the department group (and a sum column) it only dispalys the first product category. If I insert a new _group_ inside the department group it all displays correctly until I expand the salesperson node. Then it looks like this (using some more readable examples): NY Area Appliances Bill Hanson Appliances Sarah Jones Appliances Furniture Bill Hanson Furniture Sarah Jones Furniture While (as in my intial post), I'd like it to look like this: NY Area Appliances Furniture Bill Hanson Appliances Furniture Sarah Jones Appliances Furniture Lumbago www.thefirstsql.com

Bump. Is this not possible? I have done it before but then I "hacked" it by inserting a new row below the top level, merging all the columns and then inserted a sub-table inside the merged cells. I thought it was quite nasty but it did in fact work as expected.Lumbago www.thefirstsql.com