Currently, we have a cash flow statement that works for the current year. The client wanted to add a column for the previous year which is easy enough to create the second column within the Column Set with and offset of -1. However, in row set they have created, there are two lines that also has an offset value to -1 as they need balances from previous year for the current year Cash Flow statement.
When I created the Column set with an offset of -1, it will get the data from last year, however, the two lines within the row set still retrieves last year but I need it to pull 2 years back. Is there a way to do this in ARM?
Basically, if the offset within the Column Set is set to -1, I would need for the offset value within the row set to be -2.
Any help is greatly appreciated.
Joey
