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)
I think you may want to set your offset to be equal to 12 (1 will give you data from the previous row).
Thanks Kyle that did the trick