Running total - Resetting on change of field

[awhawh]

I was wondering if someone could help me regarding an issue I have with running totals.

Currently, the running totals feature allows you to select the following:

[reset] on change of field
[reset] on change of group
use a formula

What I would like to do is use the first option and select more than one field. However, the option only allows you to select one field.

My question is, could I write a formula to mirror what the the 'change of field' is doing, but with more than one 'change of' field?

The example belows shows that on the change of 'Name' and 'Account', calculate the total money that has left the account.

Name Acount Money out
(my running total)

P.Jones Account XYZ -12,000
A. Michaels Account ABC -23,000
A. Michaels Account 123 -14,000

If I create a 'change of field' for just the 'name' I would get the following:

Name Acount Money out
(my running total)

P.Jones Account XYZ -12,000
A. Michaels Account ABC -37,000
A. Michaels Account 123 -37,000

Note: I have incorporated the running total within a cross-tab.

Thank you

Adam

 

[lbass]

Can you explain why you are using running totals? I don't see any reason for you to be using them from what we have learned so far, and it would be much simpler if you used the more usual summaries in a crosstab.

-LB

 

[awhawh]

I've managed to sort of out now

Thanks

 

[lbass]

Please explain so that this thread becomes useful to others.

-LB