report 6i matrix report

[bookouri]

Can anybody point me in the right direction to do a 6i report. I think this would be some kind of matrix report, but i can't make any progress on it.

I have a table of sales:
salesman1, 1/31/2005, 3000
salesman1, 1/20/2005, 1000
salesman2, 1/30/2005, 2500
salesman1, 2/28/2005, 1500
salesman2, 2/20/2005, 1000
salesman3, 2/25/2005, 800
salesman2, 1/30/2006, 1200
salesman2, 2/27/2006, 1000
salesman3, 1/15/2006, 1500
salesman3, 2/12/2006, 800
salesman4, 2/10/2006, 500


i need to put in a YEAR and produce something like:

year 2005 2006
-------------------------------
salesman1 5500 0
salesman2 3500 2200
salesman3 800 0
salesman4 0 500
-------------------------------
Total 9800 2700

 

[nagornyi]

You need a query like this for the matrix report:

select
  salesman
, to_char(sale_date, 'YYYY') year
, sale_value
from your_table

The key is to convert date into year, so that the report could aggregate by year.
In the report Wizard select Matrix as Report Type, then salesman for Row, year for Colum, and SUM of sale_value for Cell.