Register today for Oracle CloudWorld. October 17th - 20th, Las Vegas

Register now

Hillel Cooperman, Senior VP of User Experience Design, has a message for you on Oracle CloudWorld

Watch now
How to display count(new customer account opened) from lasy year's month-to-date in analysis — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

How to display count(new customer account opened) from lasy year's month-to-date in analysis

11
Views
2
Comments
edited Apr 14, 2020 3:39PM in General Transactional Reporting (OTBI) 2 comments

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 data

Content

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:

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!