CRM On Demand - Reports and Dashboards (MOSC)

MOSC Banner

Group by results for a Summation

edited May 15, 2014 12:00PM in CRM On Demand - Reports and Dashboards (MOSC) 1 commentAnswered

Hi,

I have a report with a view currently in a table (need to know if Pivot Table is a better option for this)

Record NameDue DateNew Due DateDays from Original DateAmount
TEST Case11/1/20141/5/201441200
TEST Case21/19/20141/23/201441300
TEST Case32/20/20142/21/20141900
TEST Case42/21/20142/23/201421489

I need a SUM of the Amount column grouped by Days from Original Date.

So

Days =4 Amount = 2500 (1200+1300)

Days= 1 Amount = 900

Days= 2 Amount = 1489

and I want this SUM on the graph

X-axis = Days from Original Date

Y-axis =  SUM (Amount by Days)

Do I need a pivot?

I need the Sum visible in the table as sub total as well as plotted on the graph

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