BI Publisher (MOSC)

MOSC Banner

how to exclude in a group

edited Sep 3, 2010 5:00AM in BI Publisher (MOSC) 1 commentAnswered
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?

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center