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.
Date
Votes
1 comment
-
Marc 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.
Please sign in to leave a comment.