Forum Discussion

Helper IV

5 years ago

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...

Community Champion

5 years ago

Is this what you want?

heidibb
Helper IV
5 years ago
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
  Super User
  5 years ago
  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?
  - heidibb
    Helper IV
    5 years ago
    Hopefully you can see the file here:
    https://docs.google.com/spreadsheets/d/1nfKyzRQcJmi_o4vRwRaNgPY0TZJtjhPE/edit?usp=sharing&ouid=102760061869371054208&rtpof=true&sd=true
    
    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!