Can we Control the order of Grouping Categories?

[DavidRu1]

I'd like to place my "At Risk" items at the top of the list, and the "on target" at the bottom. Is this done with Text mode? Any help would be appreciated. Thanks, Dave Dave Rulon Great Dane Savannah, GA 912-644-2452

[DavidRu1]

Screenshot showing that we cannot sort grouping, but offers an alternative: Dave Rulon Great Dane Savannah, GA 912-644-2452

[DavidRu1]

Now that I can sort the groupings using a column, I want to hide the column. Hide a column in a view. You can build a column in a view, for purposes of sorting the view by a certain field, for example, but you can use text mode to hide it from displaying in the view. For example, to hide the Task Number column in a task report, replace the text in the Task Number column with the following: displayname= linkedname=direct querysort=taskNumber sortOrder=1 sortType=asc textmode=true value= valueformat=int width=0 The important changes in this code which make the column hidden are: - displayname must be blank; - valuefield has been replaced by value , and must be blank; - width=0 Dave Rulon Great Dane Savannah, GA 912-644-2452

[Doug_Den_Hoed__AtAppStore]

Well spotted Dave, Another relatively common technique to help with report sorting (and group sorting) is to use a calculated parameter to "decode" the status and prefix it with a numeric (similar to the picture on my "http://store.atappstore.com/2010/05/one-chart-to-rule-them-all/">One Chart To Rule Them All blog post), such as IF(Condition = "At Risk","01 At Risk",...) Regards, Doug Doug Den Hoed - AtAppStore Got Skills? Lend a hand! https://community.workfront.com/participate/unanswered-threads