jeffrey_ananta
-
Posts
2 -
Joined
-
Last visited
jeffrey_ananta's Achievements
-
already solved..thanks used this query: select .... , case extract(shipmentdate) when 1 then sum(..) else 0 end as JAN from ... where.. group by...
-
hi i'm newbie... i want to make summary report like this.. SHIPMENT REPORT / MONTH YEAR: 2010 PRODUCT JAN FEB MAR APR MAY ...... TOTAL SHIPMENT A 100 120 350 450 ....... ........... B 50 75 ..... ....... C 60 35 ....... ....... any idea? thanks before
