In the below given query, i want to display the subtotal of the following columns
1)(PRI_QTY||'.'||PRI_QTY_LS)RMQTY,
2)(PRI_QTY_BU/IU_MAX_LOOSE_1)RQTY,
3)((PRI_QTY_BU/IU_MAX_LOOSE_1)*CGCV_COST_1)RMVALUE

Kindly suggest how could i do this?

SELECT DISTINCT PRWD_WO_NO PWO_NO,
PRI_ITEM_CODE,
ITEM_NAME,
(PRI_QTY
||'.'
||PRI_QTY_LS) RMQTY,
((PRI_QTY_BU / IU_MAX_LOOSE_1) * CGCV_COST_1) RMVALUE
FROM OT_PR_ITEM,
OS_COST_GROUP_CURR_VAL,
OM_ITEM,
OM_ITEM_UOM,
OT_PR_WO_DETAIL
WHERE PRI_ITEM_CODE = CGCV_ITEM_CODE
AND PRI_ITEM_CODE = ITEM_CODE
AND PRI_ITEM_CODE = IU_ITEM_CODE
AND PRWD_SYS_ID = PRI_PRWD_SYS_ID
AND CGCV_COST_GROUP_CODE = 'CGSIL001'
GROUP BY PRI_PRWD_SYS_ID,
PRWD_WO_NO,
PRI_ITEM_CODE,
ITEM_NAME,
CGCV_COST_1,
PRI_QTY,
PRI_QTY_LS,
PRI_QTY_BU,
IU_MAX_LOOSE_1
ORDER BY PRWD_WO_NO



Yogesh

__________________
Yogesh

I don't understand how you could *EVER* get the total or subtotal of this column:
    (PRI_QTY||'.'||PRI_QTY_LS) as RMQTY

It's not a number. It's a string. You can't get the total of a text column.