Calculating Year on Year, across columns

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

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.