@Sean_Meehan, see the third page I added for issue 1, and see if that is the behavior you want.
Everyone else, the “subtract one from a particular value in the table” part, that I thought was trivial, was much harder than I thought. Which makes me think I am doing something terribly wrong. I had to use the following formula:
Sum([Table 5].Filter([Row ID]=max([Row ID])).Apples,-1)
Which seems more complicated than necessary. Or exactly as complicated as necessary? That whole first part seems like a very complicated way of getting the value of this row.apples, when I already had a filter for rowID is max rowID.