developer 2000 report buider: about matrix with group
From: Eddie Wang <hermit_wang_at_mail.qts.com.tw>
Date: 14 Dec 1999 02:33:28 GMT
Message-ID: <834a9o$r8v$1_at_news.seed.net.tw>
in matrix with group. What should I do to accumulate the total value of some specific column???
Date: 14 Dec 1999 02:33:28 GMT
Message-ID: <834a9o$r8v$1_at_news.seed.net.tw>
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 Tue Dec 14 1999 - 03:33:28 CET