If I understnad you correctly give this a try:
Your 'Submitted to Acct' should be an expression with: '=max(total <[Date Processed]> [Submitted to Acct.])'
You can also create a 'Max Submitted to Acct.' field in the script by doing a resident Group By Left Join to the original table.
Left Join (TableA)
Load [Date Processed],
max([Submitted to Acct.] as Max_Sub_to_Acct
Hope that helps,
Matt - Visual Analytics Ltd
Qlikview Dsign Blog: http://QVDesign.wordpress.com