Unable to configure sort order by required fields

(0) Share

Report

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;

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;

Is there something I need to enable?

Many thanks in advance.

I have the same question (0)

All responses (4)

Answers (1)

Suggested answer

a33ik 84,331 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Hello,

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

Are they?

Was this reply helpful? Yes No
David Jennaway 14,065 on at

Like (2)

Report
Copy link

Link copied!
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

Was this reply helpful? Yes No
Kamilcmm 171 on at

Like (0)

Report
Copy link

Link copied!

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?

Was this reply helpful? Yes No
Verified answer

a33ik 84,331 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

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

Was this reply helpful? Yes No