I have the following formula in a jet report which I reference from various NF formulas to produce a job costing report. I have been asked to summarise and subtotal this report by customer/Bill-to Name.
=NL("Rows","Contract",,"Contract No.",NL("Filter","Contract Ledger Entry","Contract No.","Posting Date",$Z$3,"Contract No.",$Z$4,"Company=",$D$8),"Global Dimension 1 Code",$X$3,"Global Dimension 2 Code",$X$4,"Shortcut Dimension 3 Code",$X$5,"Shortcut Dimension 4 Code",$X$6,"Shortcut Dimension 5 Code",$X$7,"Status",$Z$5,"Project Manager",$Z$6,"Bill-to Name",$Z$7,"Company=",$D$8)
I've read that to group information and subtotal it, I need to use the "Rows=2" field in the row above and column to the left. I managed to get the rows=2 display different group headings based on all the customer names in the "customer" table (which uses the same customer names and Bill-to Name) but I don't know how to filter the lines below so only the relevant NF formulas appear in each section. Can anyone help?
