How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?
Summary:
Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI
Content (required):
We are trying to create a Dashboard which has multiple analyses. One of the requirements is to compare Current Month's Revenue with the Previous Year's same month Revenue (i.e. Comparison of Apr-23 month with Apr-22 month, Comparison of Mar-23 month with Mar-22 and so on)
Current month (i.e. Apr-23 will be passed as a prompt in the analysis/dashboard) and the comparison column against it would be Apr-22).
OTBI Subject Area : General Ledger - Journals Real Time
Please suggest any possible ways/workaround to achieve this in OTBI. How do I get the Apr-22 column in the comparison?
0