create a static pivot report

dakyndakyn Member Posts: 36
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?
Sign In or Register to comment.