Group by results for a Summation
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 Name | Due Date | New Due Date | Days from Original Date | Amount |
---|---|---|---|---|
TEST Case1 | 1/1/2014 | 1/5/2014 | 4 | 1200 |
TEST Case2 | 1/19/2014 | 1/23/2014 | 4 | 1300 |
TEST Case3 | 2/20/2014 | 2/21/2014 | 1 | 900 |
TEST Case4 | 2/21/2014 | 2/23/2014 | 2 | 1489 |
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