Count a column group by two other column
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="'Order Entry - Orders'.Search="[FieldName] = 'ABC'""
><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>