Announcement

Collapse
No announcement yet.

Sorting by an Enum field in a report

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Sorting by an Enum field in a report

    Hi I have a Grid report that shows total Opportunity value broken down by close quarter and opportunity Stage.

    The data in the report is sorted by Close Quarter and Opportunity Stage.

    So something like this:
    Click image for larger version

Name:	Snip1.PNG
Views:	118
Size:	15.2 KB
ID:	43745

    I have the output in a graph something like this:
    Click image for larger version

Name:	Snip2.PNG
Views:	99
Size:	17.6 KB
ID:	43746

    All great so far.

    When I look at the graph, the total value of Q4 is going to be: all of the closed + all of the verbal + some of the proposal

    So I want the sort order to be "Closed" first, then "Verbal" etc. i.e. in reverse order of the Enum field.

    So, can I have the ability to sort an Enum field ASC and DESC as with other fields please.

    Thanks for your help..
Working...
X