CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Show columns with no data in a report

edited Oct 15, 2013 11:20AM in CRM On Demand - Reports and Dashboards (MOSC) 4 commentsAnswered
I'm trying to create a pivot table in a report, of opportunities by sales stage, during a given time period (1 week for example)... but only those sales stages that have opportunities associated with them, show up!

How can I create a report that shows all sales stages, regardless of whether there are opportunities that fall within it

example:

current report:

Date          closed/lost          open

10/1                  10                  50

10/2                   20                 70

ideal report:

Date          closed/lost          open          closed/won

10/1                  10                  50                  0

10/2                   20                 70                  0

Thanks

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