web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Service | Customer Service, Contact Center, Fie... / How to retrieve top 15...
Service | Customer Service, Contact Center, Fie...
Unanswered

How to retrieve top 15 total values of a field from list of opportunity records for specific month

(0) ShareShare
ReportReport
Posted on by harish c 35

Hi Experts,

   I have a requirement to fetch top 15 values of a field for a particular month on opportunity form .

 Is it possible to achieve using fetch xml  ? Please suggest the best approach to implement .

Appreciate if you share the fetch xml for the same ?

I have the same question (0)
  • LeoAlt Profile Picture
    LeoAlt 16,331 Moderator on at

    Hi partner,

    For example, I want to get the top 5 opportunity records order by "createdon" and were created in Oct 2019, here is the sample fetchxml

    <fetch top="5" version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
      <entity name="opportunity">
        <attribute name="name" />
        <attribute name="customerid" />
        <attribute name="estimatedvalue" />
        <attribute name="statuscode" />
        <attribute name="opportunityid" />
          <condition attribute = 'createdon' operator='between'>
            <value>2019-10-01 00:00:00</value>
            <value>2019-10-31 23:59:59</value>
          </condition>
        <order attribute="createdon" descending="true" />
      </entity>
    </fetch>

    Hope it helps.

    Best Regards,

    Leo

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > Service | Customer Service, Contact Center, Field Service, Guides

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 55 Super User 2025 Season 2

#2
Daniyal Khaleel Profile Picture

Daniyal Khaleel 27 Most Valuable Professional

#3
Soundari Profile Picture

Soundari 15

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans