sort and group on different fields

  • 0
  • 1
  • Question
  • Updated 4 years ago
  • Answered

I have a list of tasks... I would like to SORT by [Due Date] but GROUP by [Stage]... I haven't been able to find a way to sort on one field but group on another.

I want my tasks to show in this report as:


      Task 1      Due 2015-09-01

      Task 2      Due 2015-09-10


      Task 3      Due 2015-09-20

      Task 4      Due 2015-10-01


      Task 5      Due 2015-10-12

Photo of Kevin


  • 0 Points

Posted 4 years ago

  • 0
  • 1
Photo of Xavier Fan

Xavier Fan, Champion

  • 840 Points 500 badge 2x thumb
Do you mean you want to first Group by [Stage], then sort within each group by [Due Date]?

(your example is doing that)

You can add multiple levels of Grouping, then Sorting - within your report settings.  (Customize your report)

You'd want something like:

sort and group from low to high by [Group] grouping by "Equal Values"

sort from low to high by [Due Date]

Here's the online help on sorting and grouping in reports - the "Sorting and grouping example" shows a grouping, then sorting example.