Open the demo in new window can open the designer ReportSheet supports using formula(R.V) to get the value of any spilled cell. You can use this formula to calculate any statistic you want (e.g. YOY, MOM, Percentage, Cumulative, etc.). Functions The available functions are as follows: R.V(cell, [offset | context_cell | "CurrentPage"]), get the specific spilled cell values base on the offset or context. R.A(cell, offset), absolute offset, this function can only be used as the R.V function’s parameter. R.R(cell, offset), relative offset, this function can only be used as the R.V function’s parameter. Basic Usage As an example, if cell A2 is bound to the year column, B2 is bound to the month column, and C2 is bound to the sales column, then the functions would behave in the following manner: R.V(C2) will return all the C2 cell values as an array, so you can use the SUM(R.V(C2)) get the sum of all the C2 cell values. R.V(C2, A2) will return all of the sales as an array in the current year. C2/SUM(R.V(C2, A2)) will return the current month's sales as a percentage of the year's sales. R.V(C2, R.A(A2, 1), R.A(B2, 5)) will return the sales in the fifth month of the first year. R.V(C2, R.A(A2, 2), R.A(B2, 2)) will return the sales in the second month of the second year. R.V(C2,R.R(B2,-1)) will return the last month's sales. Create Sample From The Spread JSON This report is loading a predefined template using fromJSON. You can open the sample in a new window to view the ReportSheet settings in the Designer: