We have built couple of IR's in APEX 4.2. One of the report has 30 columns in it out of which 20 are numeric columns. Users are requesting a subtotal for those numeric columns. I tried Group option (Actions --> Group by) but it can take only upto 3 filters and will provide aggregation functions for upto 3 fields. How can we achieve this ?
Also they should be able to get updated subtotals when they filter out any columns .
Thanks in advance.
Thanks for the reply. Aggregations work but is there a way to get that sup total on the top of the report columns ? Or is there a way to get distinct records (similar to group by) in Aggregations ? Because i am getting the subtotal using Aggregations but the problem is we have over 40000 records , so to see the aggregations result user needs to go to the last page or if he shows all the records on one page but then the report is very slow. Please advice.
Unfortunately, I think that is not possible out of box.
This might require some extra code and I do not know any examples.
My Blog: http://dbswh.webhop.net/htmldb/f?p=BLOG:HOME:0