hi,
i need a fetchxml query to get won opportunity value sum of each sales agent in the quarter period, my currect query:>
<fetch distinct="false" mapping="logical" aggregate="true" >
<entity name="opportunity" >
<attribute name="actualvalue" alias="opportunity_sum" aggregate="sum" />
<attribute name="createdbyname" alias="Commercial" groupby="true"/>
<attribute name="actualclosedate" groupby="true" dategrouping="quarter" alias="Trimestre" />
<filter type="and" >
<condition attribute="statecode" operator="eq" value="Won" />
</filter>
</entity>
</fetch>
i need to know if correct or no, any helper.
Mark as answer or vote as helpful if you find it useful | Ammar Zaied [MCP]