This might be a simple question, but it is something I have never done.
Is there an easy way to sum a column on a quick report?
Basically, I created a view and based the quick report off of view, but now need a sum to appear at the bottom of a column.
like this:
Best answer by chajash
Got it to work using Grouping Sets
Works in the quick report as well.
SELECT
prod_family,
count(prod_family)as number_of_parts,
sum(extended) as total_inventory_value
FROM
agr_rep_inv_status
WHERE
frequency_class LIKE '&Frequency_Class'
GROUP BY grouping SETS
((),(prod_family))
Order by grouping
(prod_family)
hi
https://community.oracle.com/tech/developers/discussion/2329567/how-to-create-a-grand-total
+9Hi
It is possible through quick report (need to use ‘UNION ALL’ and ‘WITH’ clause). I have done that before and it was working.
WITH T AS
(SELECT PROD_FAMILY, NO_of_Parts, Total_inv_value from view1)
SELECT * FROM T
UNION ALL
SELECT SUM("Total_inv_value"),'TOTAL','' FROM T
Best Regards,
Hari
Got it to work using Grouping Sets
Works in the quick report as well.
SELECT
prod_family,
count(prod_family)as number_of_parts,
sum(extended) as total_inventory_value
FROM
agr_rep_inv_status
WHERE
frequency_class LIKE '&Frequency_Class'
GROUP BY grouping SETS
((),(prod_family))
Order by grouping
(prod_family)
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
