1 of 1 people found this helpful
You can use a simple table calculation for this.
Make sure it's set to calculate using Table Down and it'll get you the last goal number.
Put sum([Actual]) - in front of it to subtract the last goal value from each rows Actual.
I tried both methods and Paul's worked when I applied filters while Shinichiro's did not. I guess LOD was not the way to go after all. Thanks to both for taking the time to help me out.