Hallo... Gunakan command ini -------------------- SELECT PART, MAX(DECODE(date_trx,'01-JAN-08',awal,null)) AWAL_TGL1, MAX(DECODE(date_trx,'01-JAN-08',trx_in,null)) trx_in_TGL1, MAX(DECODE(date_trx,'01-JAN-08',trx_out,null)) trx_out_TGL1, MAX(DECODE(date_trx,'01-JAN-08',akhir,null)) akhir_out_TGL1, MAX(DECODE(date_trx,'02-JAN-08',awal,null)) AWAL_TGL2, MAX(DECODE(date_trx,'02-JAN-08',trx_in,null)) trx_in_TGL2, MAX(DECODE(date_trx,'02-JAN-08',trx_out,null)) trx_out_TGL2, MAX(DECODE(date_trx,'02-JAN-08',akhir,null)) akhir_out_TGL2 FROM ( SELECT DISTINCT part, date_trx, awal, trx_in, trx_out, akhir FROM ( SELECT part, trx_date date_trx, FIRST_VALUE(awal) OVER (PARTITION BY part, trx_date ORDER BY doc_no) awal, SUM(DECODE(trx_code,'I',trx_qty,0)) OVER (PARTITION BY part, trx_date) trx_in, SUM(DECODE(trx_code,'O',trx_qty,0)) OVER (PARTITION BY part, trx_date) trx_out, LAST_VALUE(akhir) OVER (PARTITION BY part, trx_date) akhir FROM trx) ORDER BY date_trx, part ) group by part ; --------------------
Contoh data dan penjelasan saya bahas di sini http://rohmad.net/2008/06/23/pivot-query-konversi-row-ke-column/ Salam, Rohmad --- In [email protected], Jack Mania <[EMAIL PROTECTED]> wrote: > > Dear Rekan Indo-oracle semua, > > Maaf saya mau minta tolong lagi, mudah"an gak bosen ya... > > Kemaren saya ada data seperti ini : > > PART TRX_DATE DOC_NO TRX_CODE AWAL TRX_QTY AKHIR > ------- -------------- ------------ --------------- ------- ------------ -------- > A 01-01-08 DOC 1 I 10 5 15 > A 01-01-08 DOC 2 > I 15 5 20 > A 01-01-08 DOC 3 O 20 10 10 > B 01-01-08 DOC 1 I 100 25 > 125 > B 01-01-08 DOC 2 I 125 25 150 > B 01-01-08 DOC 3 O 150 75 75 > A 02-01-08 DOC 4 O > 10 5 5 > > A 02-01-08 DOC 5 I 5 5 10 > > A 02-01-08 DOC 6 O 10 10 0 > B 01-01-08 DOC 4 I 75 25 100 > > B 01-01-08 DOC 5 I 100 25 125 > > B 01-01-08 DOC 6 O 125 100 25 > > > Dari data di atas saya ingin membuat tampilan seperti ini : > > PART AWAL_TGL1 TRX_IN_TGL1 TRX_OUT_TGL1 AKHIR_TGL1 AWAL_TGL2 > ------- ----------------- ------------------ --------------------- ----------------- ----------------- > A 10 10 10 10 10 > B 100 50 75 75 75 > > dst (tampilan data nyambung ke kanan mengikuti tanggal) > > Terima kasih sebelumnya atas sharing dan bantuan dari rekan-rekan > > > > Salam, > Andi > > > > > > > [Non-text portions of this message have been removed] >
