2 Replies Latest reply: Apr 2, 2013 4:48 PM by ti3r RSS

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

    ti3r
      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