CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Custom dates used in Analytics

edited Oct 15, 2013 10:22AM in CRM On Demand - Reports and Dashboards (MOSC) 4 commentsAnswered
Hi,

I'm a new user, and am trying to generate two reports, and am having different issues with both.  Any assistance will be greatly appreciated!

Report 1 - We created a custom date field named 'Installation Date'.  I'm trying to subtotal an opportunity report by the month and year.  We created a custom format for the report in mm/yy, figuring we'd simply subtotal based on this.  For some reason the 'sum' button generates a subtotal for every opportunity, it doesn't sum for each month.  It's like it's using the underlying date as the criteria for the sum.  How can I get subtotals by month on this custom date field?

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