Hello,
i'm currently working to get project list together.
currently the list is sorted according to the project numbers.
this was done by adding a "+" sign to the field.
now the users asks if he can change the sorting, so he can sort it bij "region" of sales person
(and i fear more will be asked for)
so here are my questions,
1) how can i make the "+" sign flexible so it get added according to the users wiches
2) how can i make an option list with the rows the user can use for sorting
-> rows dont come from 1 tabel
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Wouter,
As far as I know, this isn't something that is possible in Jet.
You may have to set up some sort of option that is "Sort by" and use data validation to populate it with the values you sort by.
Then have some sort of Excel IF statements to determine which sorted NL function is going to be used in your replicator.
Depending on the report, you may want to consider using the Table Builder which will create an Excel table space which can use just normal Excel sorting.
Please sign in to leave a comment.