Here you go.
So first I created a formula to pick up the first year (so we can equate this to NULL). I used an LoD, but we could have used a Table Calc
I then created the 1%
[SIP - 1%]
and then the final version combined this like so
IF MIN([Year]) = MIN([Min Year]) THEN NULL
ELSE LOOKUP(SUM(SIP),-1) + LOOKUP(SUM([SIP - 1%]),-1)
This is run across year.
I've done it in Table Form, and in the Viz so you can see what's going on
Hope that helps
1 Percent Increase_SR.twbx 22.3 KB