# Fixed Sort/order in a Table

**URL:** <https://www.dynamicsuser.net/t/fixed-sort-order-in-a-table/39976>\
**Category:** User Forum\
**Created:** [August 30, 2012, 4:00pm UTC](https://www.dynamicsuser.net/t/fixed-sort-order-in-a-table/39976 "2012-08-30T16:00:02Z")\
**Posts on this page:** 1\
**Page:** 1

<div class="post-metadata">

**Author:** ![kfons](https://avatars.discourse-cdn.com/v4/letter/k/e36b37/32.png) [@kfons](https://www.dynamicsuser.net/u/kfons)\
**Post date:** [August 30, 2012, 4:00pm UTC](https://www.dynamicsuser.net/t/fixed-sort-order-in-a-table/39976/1 "2012-08-30T16:00:02Z")

</div>

I am trying to set up a tabel and forms that is not sorted / semi sorted in a fixed format  
The table has a produduct Class, Brand and some other values.  
The keys right now are Class, Brand as there are multiple brands under one product class.  
I am fine wiht the sorting other than I want our brand listed first and the brand “other” listed last.  
I also want the Class in a particular order that is not generically sortable.  
Do I just add a field for Class priority and Brand Priority as a numeric and add them as Keys and sort that way?

This is what I want  
Class B Brand Ours  
Class B Brand X  
Class B Brand Other  
Class C Brand Ours  
Class C Brand X  
Class C Brand Other  
Class A Brand Ours  
Class A Brand X  
Class A Brand Y  
Class A Brand Other