Forum Discussion
heidibb
5 years agoHelper IV
Running Total, Not Date Based
Hello, I have a table that I'm trying to get a running total on each row for the previous 6 rows. For example, for the TermAxis 0 row (21EW6), I want to sum the In-term leads for the rows with term...
heidibb
5 years agoHelper IV
HI AJ,
Not exactly -- one thing I didn't mention this is also at the academic level as the term axis restarts based on Academic Level. I'm sorry I didn't mention that.
So, based on that, just looking at UG rows only and sorting on term axis -- my six term totals would be as follows (last column)
Ashish_Mathur
5 years agoSuper User
Hi,
Share the download link of your MS Excel workbook and show your expected result there via a formula very clearly. Also, do you want a measure solution or a calculated column solution?