
1. Re: Calculating totals PRIOR to a given year
Brent Mathison Dec 8, 2017 10:12 AM (in response to Sean Morris)RUNNING_SUM(SUM([GPA Hours]))  SUM([GPA Hours]) will work if your view is structured as you show above. The RUNNING_SUM table calculation will need to be calculated over the [Year] dimension.

2. Re: Calculating totals PRIOR to a given year
Sean Morris Dec 8, 2017 10:51 AM (in response to Brent Mathison)Hey Brent, thanks for the quick reply. I'm not sure I fully understand this solution. Will this "break" on ID? Also, where am I defining the year for which I want a prior total?

3. Re: Calculating totals PRIOR to a given year
Brent Mathison Dec 8, 2017 11:10 AM (in response to Sean Morris)Hi Sean. This solution is a table calculation  it will break on ID, depending on how you configure it. My solution is based on your visualization being structured as you showed in your original post (ID and Year). For each ID and Year, my formula calculates the running total of [GPA Hours] and subtracts the [GPA Hours] for the year on that row, in essence giving you the total [GPA Hours] for all years prior to the given year. For instance, for the row containing year 2016, my formula will give you the total for all hours through 2015 for each ID.
If you are unfamiliar with table calculations in Tableau, you should definitely learn more  there are quite a few good tutorials/resources out there. And here's a good one from Andy Kriebel that has really helped me: Tableau Tip Tuesday: Table Calculations Overview

4. Re: Calculating totals PRIOR to a given year
Deepak Rai Dec 8, 2017 11:12 AM (in response to Sean Morris)Create a integar parameter and add Years to that like 2010, 2011, 2012....2016, 2017, Show parameter Control
Use This:
This would give u GPA HOURS PER ID
{FIXED [ID]:SUM(IF Year<Year([Year Parameter]) THEN GPA HOURS END) }
For Quality Points use this;
{FIXED [ID]:SUM(IF Year<Year([Year Parameter]) THEN Quality Points END) }
Now when You will select any Year from parameter, The Result would be calculating for YEARS PRIOR TO SELECTED YEAR.
Thanks
Deepak