Trial and error is not working. I need some help setting up the summary tool for “Field 2”. Please see below, I want “Field 2” to do the following. Can someone help me with the correct settings?
Field 1 (Monthly Total) Field 2 (Previous Totals)
Row1 Month Total (A) 0
Row2 Month Total (B) Total of Field 1 (A)
Row3 Month Total (C) Total of Field 1 (A+B)
Row4 Month Total (D) Total of Field 1 (A+B+C)