My out put look like this
IMPORT AMOUNT EXPORT AMOUNT
ITEM_A 300 500
ITEM_B 400 900
ITEM_C 500 200
OTHER 600 500 ----- How to find this value
TOTAL IMPORT - 1800
TOTAL EXPORT - 2100
How to make query to find amount for other_item
ie import = 1800-(300+400+500) = 600
ie export = 2100-(500+900+200) = 500
I'm not sure I understand the problem.
If you don't want the rows where item_name is ITEM_A, ITEM_B or ITEM_C, then add
NVL (item_name, 'OK') NOT IN ('ITEM_A', 'ITEM_B', 'ITEM_C')
to your WHERE clause. If you're generating thse figures through a UNION (as in your first message), then why not just omit those parts of the UNION?
As mentioned above, you need to post CREATE TABLE and INSERT statements for a little sample data, and the exact output you want from that sample data. Explain how you get those results from that data.
See the forum FAQ: https://forums.oracle.com/message/9362002