how to exclude in a group
Hi,
Given the following data, I want to get the sum of Day1, Day2, etc. for each product line, but only for the ORGANIZATION_CODE of IND and AER.
<G_PRODUCT_LINE> <PRODUCT_LINE>860</PRODUCT_LINE> <LIST_G_ORGANIZATION_CODE> <G_ORGANIZATION_CODE> <DATE_REQUESTED>01-SEP-10</DATE_REQUESTED> <DATE_SCHEDULED>01-SEP-10</DATE_SCHEDULED> <SHIP_DATE>01-SEP-10</SHIP_DATE> <ORDER_NUMBER>222749</ORDER_NUMBER> <ORGANIZATION_CODE>WES</ORGANIZATION_CODE> <LINE_NUMBER>1</LINE_NUMBER> <ITEM_NUMBER>R210517054</ITEM_NUMBER> <PR_TIME>0</PR_TIME> <ONTIME>1</ONTIME> <DAY1>0</DAY1> <DAY2>0</DAY2> <DAY3>0</DAY3> <DAY4>0</DAY4> <DAY5>0</DAY5> <ABOVE6>0</ABOVE6> </G_ORGANIZATION_CODE> <G_ORGANIZATION_CODE> <DATE_REQUESTED>07-SEP-10</DATE_REQUESTED> <DATE_SCHEDULED>02-SEP-10</DATE_SCHEDULED> <SHIP_DATE>01-SEP-10</SHIP_DATE> <ORDER_NUMBER>719381</ORDER_NUMBER> <ORGANIZATION_CODE>AER</ORGANIZATION_CODE> <LINE_NUMBER>1</LINE_NUMBER> <ITEM_NUMBER>WR1670008S</ITEM_NUMBER> <PR_TIME>1</PR_TIME> <ONTIME>0</ONTIME> <DAY1>0</DAY1> <DAY2>0</DAY2> <DAY3>0</DAY3> <DAY4>0</DAY4> <DAY5>0</DAY5> <ABOVE6>0</ABOVE6> </G_ORGANIZATION_CODE> <G_ORGANIZATION_CODE> <DATE_REQUESTED>03-SEP-10</DATE_REQUESTED> <DATE_SCHEDULED>03-SEP-10</DATE_SCHEDULED> <SHIP_DATE>01-SEP-10</SHIP_DATE> <ORDER_NUMBER>910264</ORDER_NUMBER> <ORGANIZATION_CODE>IND</ORGANIZATION_CODE> <LINE_NUMBER>3</LINE_NUMBER> <ITEM_NUMBER>WR590010D</ITEM_NUMBER> <PR_TIME>1</PR_TIME> <ONTIME>0</ONTIME> <DAY1>0</DAY1> <DAY2>0</DAY2> <DAY3>0</DAY3> <DAY4>0</DAY4> <DAY5>0</DAY5> <ABOVE6>0</ABOVE6> </G_ORGANIZATION_CODE> <G_ORGANIZATION_CODE> <DATE_REQUESTED>10-SEP-10</DATE_REQUESTED> <DATE_SCHEDULED>03-SEP-10</DATE_SCHEDULED> <SHIP_DATE>01-SEP-10</SHIP_DATE> <ORDER_NUMBER>8005632</ORDER_NUMBER> <ORGANIZATION_CODE>IND</ORGANIZATION_CODE> <LINE_NUMBER>4</LINE_NUMBER> <ITEM_NUMBER>WR620010DTPR</ITEM_NUMBER> <PR_TIME>1</PR_TIME> <ONTIME>0</ONTIME> <DAY1>0</DAY1> <DAY2>0</DAY2> <DAY3>0</DAY3> <DAY4>0</DAY4> <DAY5>0</DAY5> <ABOVE6>0</ABOVE6> </G_ORGANIZATION_CODE> <G_ORGANIZATION_CODE> <DATE_REQUESTED>06-SEP-10</DATE_REQUESTED> <DATE_SCHEDULED>03-SEP-10</DATE_SCHEDULED> <SHIP_DATE>01-SEP-10</SHIP_DATE> <ORDER_NUMBER>441002256</ORDER_NUMBER> <ORGANIZATION_CODE>IND</ORGANIZATION_CODE> <LINE_NUMBER>1</LINE_NUMBER> <ITEM_NUMBER>WR32619</ITEM_NUMBER> <PR_TIME>1</PR_TIME> <ONTIME>0</ONTIME> <DAY1>0</DAY1> <DAY2>0</DAY2> <DAY3>0</DAY3> <DAY4>0</DAY4> <DAY5>0</DAY5> <ABOVE6>0</ABOVE6> </G_ORGANIZATION_CODE> </LIST_G_ORGANIZATION_CODE> <CS_ONTIME>1</CS_ONTIME> <CS_PRTIME>4</CS_PRTIME> <CS_DAY1>0</CS_DAY1> <CS_DAY2>0</CS_DAY2> <CS_DAY3>0</CS_DAY3> <CS_DAY4>0</CS_DAY4> <CS_DAY5>0</CS_DAY5> <CS_ABOVE6>0</CS_ABOVE6> <CS_ORGN_CODE>WES</CS_ORGN_CODE> </G_PRODUCT_LINE> Any suggestions?0