Question

Year on year % change

  • 10 May 2018
  • 2 replies
  • 1161 views

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


2 replies

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

Reply