OBIEE creating variances the easy way using $ sign

CREATE VARIANCES THE EASY WAY

Create a table or Pivot table

A way to do this dynamically, without hard coding the years seem to be possible by using $1-$2.

Use $x to reference the columns where x=1,2,3…etc.

This will avoid you to re-write these reports, which is what happens when values are hardcoded