BI Publisher (MOSC)

MOSC Banner

Count a column group by two other column

edited Aug 2, 2016 5:00AM in BI Publisher (MOSC) 7 commentsAnswered

Hi

I need to create a BIP report using BIP Desktop.

I have following xml

<?xml version="1.0" encoding="UTF-8"?><ListOfBipWorkareawiseTransaction

OrderEntrySales_QueryString="&apos;Order Entry - Orders&apos;.Search=&quot;[FieldName] = &apos;ABC&apos;&quot;"

><OrderEntry-Orders>

<CBiO2CreatedBy>1-1GVZ</CBiO2CreatedBy>

<CBiO2CreatedDate>09/15/2015 19:38:15</CBiO2CreatedDate>

<CBiO2CreatedDateCanonical>2015-09-15</CBiO2CreatedDateCanonical>

<CBiO2CreatedbyPerson>EBARBHA</CBiO2CreatedbyPerson>

<CBiO2ReceiptCreatedDate/>

<CBiO2ShopId>128</CBiO2ShopId>

<CBiO2ShopName>Default Organization</CBiO2ShopName>

<CBiO2ShopType>Branch</CBiO2ShopType>

<CreatedByName>EBARBHA</CreatedByName>

<OrganizationIntegrationId/>

<PrimaryOrganization>Default Organization</PrimaryOrganization>

<PrimaryOrganizationId>0-R9NH</PrimaryOrganizationId>

<ListOfOrderEntry-LineItems>

<OrderEntry-LineItems>

<CBiO2HeaderCreatedBy>EBARBHA</CBiO2HeaderCreatedBy>

<CBiO2HeaderCreatedDate>09/15/2015 19:38:15</CBiO2HeaderCreatedDate>

<CBiO2HeaderCreatedDateCanonical>2015-09-15</CBiO2HeaderCreatedDateCanonical>

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