Hello All,
Great site here! I've got a question which I can't seem to figure out. My report currently pulls contract acct and sub acct information along with date, value, etc. What I really want to happen is to be able to roll up all sub acct dollar values and show the lastest contract end date possible.
Here's a rough example of the table:
Cmf Acct Cmf Sub Acct End Date Value
-------- ------------ -------- -----
3333 000 9/9 $0
3333 001 9/9 $100
3333 002 9/8 $750
3333 ZZZ 9/9 $0
I'd like the output to be something like:
3333 (ALL) 9/9 $850
Anyone have any ideas? Thanks in advance for the help.
Tyler
Great site here! I've got a question which I can't seem to figure out. My report currently pulls contract acct and sub acct information along with date, value, etc. What I really want to happen is to be able to roll up all sub acct dollar values and show the lastest contract end date possible.
Here's a rough example of the table:
Cmf Acct Cmf Sub Acct End Date Value
-------- ------------ -------- -----
3333 000 9/9 $0
3333 001 9/9 $100
3333 002 9/8 $750
3333 ZZZ 9/9 $0
I'd like the output to be something like:
3333 (ALL) 9/9 $850
Anyone have any ideas? Thanks in advance for the help.
Tyler