Question

Year on year % change

Hi there

I would like to show year on year % change for sales data set out in month totals.

So row totals then these totals showing y-o-y % changes from the month 12 months prior

I have tried the below but the numbers just don’t look right

(<field_name - offset(<field_name>,1)) / offset(<field_name,1)

Thanks!

N

Userlevel 1

Hi @Nick_Dempsey,

I think you may want to set your offset to be equal to 12 (1 will give you data from the previous row).

Best,

Kyle

Thanks Kyle that did the trick

Sign up