Custom Sort

I need a bit of help with the following that I think I might be needing to integrate sort or orderedby expressions but I am not sure.

My Data:

Global Status Table
2X_d_d2cbf966f92190d8f51a9505fa8759e8400d8deb.png

Product Table
-Global Status is Ref to the Global Status Table

2X_0_09d7cb52fcca549cbd1473faef37e24d38ec5fed.png

Product View
-Global Status is

2X_6_6f4e1ce022da05e62dc798387a5d365d84b3f3b9.png

Questions:

I only have the option to sort Global Status by Ascending or Decending order. How do I sort in either:

  1. Custom selecting / sorting the data records in Global Status column (Similar to custom sort in excel)
    or
  2. Sort by the numercial order added in Global Status Order without needing to unnessasary pull the data into the Product table via a Virtual Column and sort by that instead.
0 10 1,804
10 REPLIES 10
Top Labels in this Space