S
Sammy
I have data in the following columns
The 5 columns of data are as below
A B C D E
Acct Subacct Project DebitAmt CreditAmt
I want to output via a report /or send to Excel data that will get
summarised DebitAmt and CreditAmt by
Account, Subaccount, Project
I was trying to sum of the Totals of the DebitAmt
and the CreditAmt for each Distinct (Acct, Subacct, Project)
So I would have distinct
Acct Sub Project Sum(DebitAmt) Sum(CreditAmt)
I would really apprecaite some guidance on howI can accomplish this as I am
a complete novice at this.
Thanks
Sam
The 5 columns of data are as below
A B C D E
Acct Subacct Project DebitAmt CreditAmt
I want to output via a report /or send to Excel data that will get
summarised DebitAmt and CreditAmt by
Account, Subaccount, Project
I was trying to sum of the Totals of the DebitAmt
and the CreditAmt for each Distinct (Acct, Subacct, Project)
So I would have distinct
Acct Sub Project Sum(DebitAmt) Sum(CreditAmt)
I would really apprecaite some guidance on howI can accomplish this as I am
a complete novice at this.
Thanks
Sam