Anyone know if its possible to sort an NF field using some kind of Excel formula?
Here is my NF code…=IF(ISERROR($D13),"",NF($D13,"Global Dimension 1 Code")). Field $D13 is my NL code.
I just want to short my filtered records by the dimension code returned in the NF field.
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi Antz,
The NF function is not the function which creates the rows of data and therefore it has nothing to do with the sorting. The NL replicator which is creating the data is where you can sort. In your NL function, you would need to add the filterfield/filter: "+Global Dimension 1 Code","*" to sort ascending by the Global Dimension 1 Code field. If you are already filtering by Global Dimension 1 Code in the NL formula, you can just add the + in front of the filter field (or - for descending sort). Does this work for you?
Regards,
Hughes -
Jet Reports Historic Posts THanks it worked great!!
-
Jet Reports Historic Posts In the line of this topic I've the following question:
Is it possible to let Jet return only the e.g. top/bottom 20 when I sort
I try to create a report with only the top 20 customers in sales.
When I use the sort function I get all my customers.
Thanks! -
Jet Reports Historic Posts Have you tried this Konijnenburg?
FilterfieldX: "Limit=" (or "Limiet=" in Dutch)
FilterX: "20"
Please sign in to leave a comment.