How to do comparison with a baseline period? — Oracle Analytics

Oracle Analytics Cloud and Server

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

How to do comparison with a baseline period?

Received Response
11
Views
2
Comments
User_8ZWKB
User_8ZWKB Rank 3 - Community Apprentice

Hi,

I am trying to create a report where user is prompted to select which is their baseline period.  The sales number will be compared with the baseline year (the trend column in the table below).

For example,

YearSalesTrend
2010$150,000100%
2011$175,000117%
2012$165,000110%
2013$185,000123%

2014

$200,000133%

I have tried to use AGO function.  However, the AGO cannot accept number of periods in between as a calculation.  So, some like CURRENT_YEAR - BASELINE_YEAR as the number of periods in AGO function.

Is there any other function that I can use to compare sales numbers with a baseline sales number?

Thanks,

Sean

Answers