Your documentation shows how to reference a previous item in the same column ( i.e., [Total (-1)] ) when trying to do a running total. Now, how do you reference the previous item when it's in a previous group? [Total(-1)] doesn't work here, and neither does [Total(-2)] or [Total(-3)].
TIA
By Group, I mean OutlookGroupBy group. I am grouping a series of payments by Year, and the running total needs to be able to use the running total from December of the year before. The formula works fine when the grid is ungrouped, but I cannot find the correct way to reference the previous row when it's in the previous OutlookGroupBy group (in this case, the previous year).
Does no one have an answer for this? I can't believe someone hasn't run into this problem, surely SOMEONE has had to group/ungroup results and do a calculation formula that calculates the same regardless of the grouping!