Sort multiple talbes by calculated field


How can I sort a field retrieved from 2 tables (for example: field "No." from "Sales Header" and "Sales Header Archive") by a calculated field of both tables (for example: field "Amount").

When I try to sort with NL("Rows") using one of the tables and the calculated field that seems to work fine, but I can't manage to sort out the field from both tables at same time. Is it possible?

Thanks in advance


Please sign in to leave a comment.