Is it possible to sort by a field from another table? I thought it was, and I thought it was the same technique as Sort by Sum. However, I can't get it to work.
If it's possible, please share technique. If not possible, I'll survive.
Is it possible to sort by a field from another table? I thought it was, and I thought it was the same technique as Sort by Sum. However, I can't get it to work.
If it's possible, please share technique. If not possible, I'll survive.
This is difficult to answer properly without more information. I'm assuming you're using Table Builder or NL(Table).
That being the case, you should be able to add a sort after the new table has been created. So your complete formula might look something like:
=NL("Table","[table 1]","Fields=",{B5:H5},"TableName=","Whatever","Filters=",B2:C3,"Link=,B4,"+Field in new table","*")
Using https://support.jetglobal.com/hc/en-us/articles/218953718-Sorting-Your-Jet-Reports as a source.