Hi,
I’m looking for a way to calculate Year on Year performance, across columns.
Effectively the columns are Qtrs, with values in rows, and I need to calculate the (values of current column / column - 4 (4 qtrs [1 year] ago ) -1.
Does anyone have a smart way to achieve this?
Seems like I might be better off pivoting and using a lag column to achieve this, doesn’t seem to be a lag row option available.
geoffreyb s way seems totally fine
You could also use a simple math node for that if I understand you correctly
1 Like
I wanted to have it so I didn’t specifically have to indentify the columns, so I could just offset each column by four. I managed to find a solution by pivoting the data and then using a moving aggregation + math formula.
3 Likes
system
Closed
November 17, 2020, 7:38pm
5
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.