Creating Cross tab with DATE, sum(qty) and number from IREPORT

[pcouas]

Hi

 

I have an Oracle10 table like this CARSMODEL_ID, QTY and DATE(YYYYMMDDà i search an Crosstab by Month(YYMM) for each CARSMODEL_ID

I want an array like this

CARS  JAN FEB MAR APR

1          100    10  20 300

2          200  100 150 10

3         150  20 100 20

I have currently

CARSMODEL_ID, QTY and DATE(YYYYMMDDà i search an Cros

1,50 20160101

1 50,20160102

2 150,20160102

2 50,20160102

3 150,20160102

1,10 20160202

2,50 20160202

2,50 20160204

I Have tried crosstab, butwithout succes

 

Regards

Phil

 

[pcouas]

Ok , have found Solution Closed Question