Tip & Trick 4: Calculated Fields using values in other rows

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

Leave a Reply

Your email address will not be published. Required fields are marked *