How to display count(new customer account opened) from lasy year's month-to-date in analysis
Summary
How to display the amount of new customer account opened in last year's month-to-date, together with this year's month-to-date dataContent
Hello Oracle Community,
In OBIEE, how can the amount of new customer account (dealer) opened from last year's month-to-date (MTD) be displayed together with the amount of new customer account opened MTD this year.
I have been able to display the amount of new customer account opened MTD this year per sales person in both per brand and across all brands, as well as showcasing their ranking. The result is illustrated in enclosed screenshot. However, last year's MTD data could not be displayed. It either comes out in error number or does not show up despite using the below formulas:
1