Another little tip on Oracle BI based on a question I once got asked: How to use formulas in calculated fields to compare values from different rows.
In the video posted above, I will be creating a report where I compare closed opportunity revenue over multiple years without using a pivot table as can be seen in the screenshot below.
The report containing the end result can be downloaded here: Comparing Rows
