CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Elapsed months in column filter

edited Jul 15, 2016 3:19PM in CRM On Demand - Reports and Dashboards (MOSC) 5 commentsAnswered ✓

Hi All,

I'm trying to create an account report that shows each customer, their start date and then the amount of sales for Year 1, Year 2, Year 3, etc.  So, basically, the Year one column would be all sales within the first 12 months of the start date, the Year two column would be all sales between 12 months and 25 months from their start date.  I have tried a few different strategies and can't seem to get it.  I'm in the opportunities subject area and the satrt date field is a custom date field (not a timestamp).

Appreciate any help!

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center