I am trying to sort a report by the sum of field.
Scenario is as follows:
I have a field "Product_Code" within the table "SYSADM_CUST_ORDER_LINE"
I need the sum of "TOTAL_AMT_ORDERED" that is also within the table "SYSADM_CUST_ORDER_LINE" for all the same "Product_Code"
I want it as a new column in the query so I can sort by the SUM on a report.