Forum Discussion
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...
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?
Hopefully you can see the file here:
Formula is in the last column. It's a simple sum of six rows. File is sorted by academic level and then by term axis so the correct six rows are being summed.
It would be a measure solution that I'm looking for.
Thank you for taking a look!
Hi,
I get an Access Denied message.