How to ORDER inline items

[tom_smith]

Hi,

I'm trying to figure out where and how I need to ORDER an inline collection of objects.

In the example above a Rubric has both Sections and Marks Bands.  I first group them by Sections (Content & Structure, Vocabulary, Grammar etc) but then want to order the Marks Bands by a numerical column called Upper. You can see the red item is a Fail item with an Upper of 40 but comes before Pass because F comes before P.  They seem to be only orderable by name.

I tried wrapping a ORDERBY around the REF_ROW but that doesn't work.

ORDERBY([Upper], REF_ROWS("Criteria", "Marks Band"))

Any clues as to the best way to do this? I might have expected it to be in the View Options, but there I can only define the Table, not the Column within the table.

Thanks 

Tom

[WillowMobileSys]

---

@tom_smith wrote:

but then want to order the Marks Bands by a numerical column called Upper.

---

Then why not specify [Upper] as the sort column instead of [Marks Band]?  

You do not need ORDERBY, you can achieve all of the sorting in the view definition.   When you apply Grouping, the Groups always set the PRIMARY sort columns.  The Sort by property will then sort the detail rows.