Allow OFFSET to be used on summary line item formatted as Formula.
I am trying to calculate a percentage change from prior year or prior quarter at the summary level. For example, year-over-year % changes using a formula at the aggregated level: Total Growth in Net Sales / OFFSET(Net Sales, -1, 0).
A previous resolution provided was to put the OFFSET function on a different line, and make a reference line item a Formula summary. However this would substantially increase the amount of line items that I would need as I would need to have two lines for every single growth metric.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.