caranya mudah2 manjur :
dw: pake  Cross tab
cross tab terbagi 3 : ROws , columns dan values

masukan kolom dari table yang diingin spt ini:
ROws : codebrg 
columns : type_sales 
values : qty

setelah itu jadilah.... mudah2an..

--- hery purwoko <[EMAIL PROTECTED]> wrote:

> Dear All,
> mohon bantuannya, saya punya tabel dengan data
> berikut :
> type_sales       codebrg      qty
> A                       111            1
> B                       111            2
> C                       111            3
> D                       111            4
> 
> bagaimana caranya agar outputnya bisa seperti
> berikut
> 
> codebrg       type sales qty                        
>     total D-A+B+C
>                   A           B          C        D
> 111             1            2           3         4
>               8
> 
> please ada yang tahu bagaimanakah caranya
> 
> Terima kasih
> 
> Hery
> 



 
____________________________________________________________________________________
Access over 1 million songs - Yahoo! Music Unlimited 
(http://music.yahoo.com/unlimited)



-----------------------------------------------
IndoPB - Indonesia PB User Group 
An Indonesian PowerBuilder User Group's Event
2nd PowerBuilder Update
Rumah Sakit Jantung Harapan Kita
26/27 August 2006
To Register : 
http://groups.yahoo.com/group/indopb/database?method=addRecord&tbl=4 
Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/indopb/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/indopb/join
    (Yahoo! ID required)

<*> To change settings via email:
    mailto:[EMAIL PROTECTED] 
    mailto:[EMAIL PROTECTED]

<*> To unsubscribe from this group, send an email to:
    [EMAIL PROTECTED]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/
 

Kirim email ke