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 / Microsoft Dynamics 365 | Integration, Dataverse... / Unable to configure so...
Microsoft Dynamics 365 | Integration, Dataverse...
Answered

Unable to configure sort order by required fields

(0) ShareShare
ReportReport
Posted on by Kamilcmm 171

I have added two fields into a view, and for some reason im unable to sort the records by those fields. Please see screenshot below;

pastedimage1574251602741v1.png

I have added 'Estimated Mobile profit' and 'Total Profit' but when I click on the headers it doesn't sort it neither ascending nor descending. 

I tried to configure the sort order however, those fields don't even come up, please see below;

pastedimage1574251709124v2.png

Is there something I need to enable?

Many thanks in advance. 

I have the same question (0)
  • Suggested answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    Hello,

    If fields are calculated you can't use it in sorting - docs.microsoft.com/.../calculated-rollup-attributes

    Are they?

  • David Jennaway Profile Picture
    David Jennaway 14,065 on at

    Are these fields calculated fields ? If so, there are some cases where you cannot sort on calculated fields:

    • If they reference fields in the parent entity
    • If they reference other calculated fields
    • If they reference logical fields (like the label of an option set)

    See https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/customize/define-calculated-fields for a bit more detail

    You also can't specify a sort order on fields from a parent entity, but it doesn't look like this is the issue here

  • Kamilcmm Profile Picture
    Kamilcmm 171 on at

    Ah ok yes the 'Total profit' field is a calculated field that is a total of two calculated fields.

    I guess there is no way to bypass this? i.e. make a separate field that copies the number from the 'Total Profit' but as a standard line of text or a whole number so that it can be sorted?

  • Verified answer
    a33ik Profile Picture
    a33ik 84,331 Most Valuable Professional on at

    I believe creation of real field and copying of calculated value into it should resolve your issue.

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 > Microsoft Dynamics 365 | Integration, Dataverse, and general topics

#1
Martin Dráb Profile Picture

Martin Dráb 47 Most Valuable Professional

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 38 Super User 2025 Season 2

#3
Pallavi Phade Profile Picture

Pallavi Phade 32

Last 30 days Overall leaderboard

Featured topics

Identifying an Org as CDS or Dynamics
Get batch job history log from D365 FO to Power Automate
Gross and Net Weight of Shipments feeding back into Sales Order (from External Source)

Product updates

Dynamics 365 release plans