Hi All, I have below table. Cust_No Cust_cntry Date total amount old balance banalce 1001 IN 4/30/2012 10,000.00 2,000.00 8000 1001 IN 4/30/2012 10,000.00 2,000.00 8000 1002 UK 4/31/2012 15,000.00 3,000.00 12000 1002 UK 4/31/2012 15,000.00 3,000.00 12000 But i want develop this output. how to get this... Cust_No Cust_cntry Date total amount old balance 1001 IN 4/30/2012 10,000.00 2,000.00 8000 1001 IN 4/30/2012 10,000.00 2,000.00 8000 1001 0.00 0.00 0.00 1002 UK 4/31/2012 15,000.00 3,000.00 12000 1002 UK 4/31/2012 15,000.00 2,000.00 13000 1002 0.00 0.00 -1000 could i request all to suggest how to get this output?
... View more