Group wise total of Block in oracle form [message #604489] |
Tue, 31 December 2013 07:38  |
irfankundi786@yahoo.com
Messages: 269 Registered: February 2009 Location: pakistan
|
Senior Member |
|
|
i have a block with these columnsrno, fin-year Ename All_Amount C_amount
1 2012-2013 A 50 10
2 2012-2013 B 30 10
3 2012-2013 C 10 20
=========================================================
Total 90 40
============================================================
srno, fin-year Ename All_Amount C_amount
1 2013-2014 d 20 5
2 2013-2014 F 30 10
========================================================
50 15
i want to total block fin_year wise as i mention above how i can handled in block.
how i can add summary?
[EDITED by LF: applied [code] tags]
[Updated on: Tue, 31 December 2013 13:17] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|
Re: Group wise total of Block in oracle form [message #604506 is a reply to message #604502] |
Tue, 31 December 2013 08:53   |
irfankundi786@yahoo.com
Messages: 269 Registered: February 2009 Location: pakistan
|
Senior Member |
|
|
i think this not fullfill my requirement. please see my post i need the finyearwise sum
srno, fin-year Ename All_Amount C_amount
1 2012-2013 A 50 10
2 2012-2013 B 30 10
3 2012-2013 C 10 20
=========================================================
Total 90 40
============================================================
srno, fin-year Ename All_Amount C_amount
1 2013-2014 d 20 5
2 2013-2014 F 30 10
========================================================
50 15
in one block this all is done need subtotal finyear...
[EDITED by LF: applied [code] tags]
[Updated on: Tue, 31 December 2013 13:21] by Moderator Report message to a moderator
|
|
|
|
|
|
|
|