Hello,
I am trying to create some sort of link between the Sales line table and the Sales header table to show the amount of a specific item ordered each month. So I have this sum from the sales line table:
=NL("Sum","Sales Line","Quantity","No.",$C13,"Variant Code",$E13,"Document Type","Order")
I would like to filter this by the order date on the Sales Header table, I am kinda new and am having trouble using the NL("Filter) and "Link=", I keep getting #values. I want the filterfield to be the order date and the filter to be a cell reference to a date range in another cell. I am using the Document Type, order, as the common field in both the sales line and sales header table, I am not even sure that it makes any difference.
Hopefully this is basic enough to get a quick response! Thanks for reading my post. :D
Date
Votes
2 comments
-
Jet Reports Historic Posts =NL("Sum","Sales Line","Quantity","No.",$C13,"Variant Code",$E13,"Document Type","Order", "Link=","Sales Header","Document Type","=Document Type","No.","=Document No.","Order Date",OTHERCELL ) -
Jet Reports Historic Posts Thank you very much. Your solution worked great. I had used link= in a similar fashion but did not include the "no.","=document no.". That seems to have been just what was needed. Thanks again! :)
Please sign in to leave a comment.