1 Reply Latest reply on Sep 24, 2012 10:59 PM by comment

# Line Graph: Cumulative earnings

At my school, the kids earn money each week, fake money that they use to apply towards school supplies and towards end-of-trimester field trips like skating or bowling.

I haven't figured out a way to create a line graph. I'd like the X axis to be each week, and the y axis be their cumulative earnings for the trimester. If a kid earns \$8 the first week and \$10 the second week, how could i create a line graph that shows \$8 and then \$18 (week 1 + week2)? There seems to be a way; I just can't find it.

PS. Each advisor deposits the amount into the database. Each week its deposited, a week number is calculated. Entering the deposit on 9/24 would give us a school week of 6. So the students right now have 6 deposits in the system and each is marked by a week: Week 1, 2, 3, and so on.

That keeps each week separate allowing me to do things with the data.

Thanks

jb

• ###### 1. Re: Line Graph: Cumulative earnings

Have you tried using a running total summary field?

---

BTW, can you be sure that each child earns money every week?