Sign Up for Training |
Jet Express Support |
Jet Reports Company Site
Jet 365 Financials
Jet Professional
Jet Enterprise
Downloads
Community
Submit a Request
Give Feedback

Grouping and Subtotaling


Since you can create a dynamic list using an NL function, the next logical step is to group the items in the list. The mechanism for grouping is nested NL functions.

Help Topics

Grouping Tutorial
Multi-Level Grouping
Videos

 

Nesting NL functions

When one NL is inside the region of another, the NL functions are nested. The outer NL function lists the grouping criteria, and then the inner NL can use the results of the outer NL as a filter.

When you select report mode, the outer NL will evaluate first, inserting copies of its region for each record and filling in its data values.

Once the outer NL has expanded, the inner NL will expand, making copies of its own region for each of the outer NLs.

Jet Professional evaluates the NL functions from left to right, and top to bottom so if you have put one NL function that acts on rows in cell D4, and one that acts on columns in cell B5, Jet Professional will evaluate cell B5 first.

For more information about Grouping and Subtotaling see:

The Grouping and Subtotaling Tutorial

The Multi-Level Grouping and Subtotaling Tutorial

and our Grouping Reports Videos:

Adding Filters,
Lists, and Totals

Adding
Groupings 
Adding Columns
and Dimensions
Adding Sheet
Grouping
Adding
Report Options
 
 
 
 
 
 
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request

Comments