This content has been marked as final. Show 3 replies
1 of 1 people found this helpful
Hi David, I can think of three ways to do this:
- Edit your data source itself to include the prior period value in each record. This would be the only way to get the prior-period value at the row level.
- Put the dates into your sheet and then use LOOKUP() to get the value from the previous period. This only works in a sheet that is arranged with the dates in the level of detail, though. It won't work as a row-level calc.
- Duplicate your data source and do blending so that the duplicate source is offset back by one period. This will only allow you to compare aggregated values, though. You still won't get row-level results with this.
I used the lookup function as you suggested. I had hoped there was a better way, but that works. Thank you very much.