We are trying to create a Income Statement for actuals vs Budget and previous years (PY in the table below) value. Showing both monthly value and YTD. We have our metrics on the rows in the table below.
YTD is created as a calculated item using Cumulate and all PY columns are also created as calculated items, using an Offset on version Actuals.
The problem is that I can’t get the column to the very right “Var PY %” to show the right value, no matter how I define the calculation priority. If I put it before YTD it is blank and if I put it after YTD it calculates the variance as a percentage for each month and then sums all these percentages together which results in a totally incorrect value.
Any ide how to set up the calculations to make this work?





