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.
Campaign Hand Addressed (break format column)
Campaign Travel Check
Sum:900 This is row I need to add
This works when I run it in SQL Developer. Now I enter this for my report query in APEX and I get the "not a GROUP BY expression.
FROM t3_mail_piece t
WHERE t.week_id = 11
GROUP BY ROLLUP(t.campaign_id, t.market_id)
ORDER BY t.campaign_id
What is different?