create a static pivot report

dakyn

I need to develop a report with this dataitem:
Customer
Sale Line
Item

My problem is:
I need to group by customer and then by custom fields in Item table.
This field is named "Division" that group the item in specific sectors.
I need to print on report some totals of "Sales Line"."Line Amount" group by Division.

Then

Customer1
Division1 TotalAmount1
Division2 TotalAmount2
Division3 TotalAmount3
...
Customer2
...

Can You help me?