This discussion is archived
2 Replies Latest reply: Apr 2, 2013 2:48 PM by ti3r RSS

Interactive Report Need total of aggregate (sums) where break format used

ti3r Newbie
Currently Being Moderated
I have an interactive report that uses break formatting. When I do an aggregate (sum) for the Quantity Column I get the sums for each campaign_id (used for the break format column). This is great. However, at the bottom of the report I need a grand total for all campaign ids (a sum of the sums) in a new row at the bottom of the report. Is this possible?

I can't paste a screenshot here to show but her is a simple one column example - I can't make the columns stay lined up but I think you can see what I need.
{code

Campaign Hand Addressed (break format column)
Quantity
100
200
Sum:300
Campaign Travel Check
Quantity
100
500
Sum:600
Sum:900 This is row I need to add



}

Oracle 11GR2
APEX 3.2.1

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points