How to compare Prior Year Month Revenue with Current Month's Revenue in OTBI?
Comparison of current month's revenue with last year's same month's revenue in Oracle Fusion OTBI
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?