Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> developer 2000 report buider: about matrix with group
in matrix with group. What should I do to accumulate the total value of some
specific column???
for example:
department: A
AcctNo Jan. Feb. Mar. 621001 1,000 2,000 3,000 621002 2,000 2,000 500 621003 3,000 500 1,000 621004 1,000 1,500 2,500 -------------------------------------------- Total Value: 7,000 6,000 7,000
department: B
AcctNo Jan. Feb. Mar. 621001 1,500 2,000 3,000 621002 2,000 2,000 500 621003 3,000 400 2,300 621004 500 1,500 2,100 ------------------------------------------- Total Value: 7,000 5,900 7,900 ========================== Accu Value: ? ? ?
How to set up the Accu Value filed ?
(these value should be 14000 11900 14900)
Thankx a lot :) Received on Mon Dec 13 1999 - 20:31:38 CST