Hi all,
I'm busy creating a new report which will have the intake figures per customer shown on it. Because this report only needs to show the figures for customers in a certain country and with a certain cost centre, I created a NL function with the country codes as a filter. See attached files 1354 and 1357 (client names made invisible). But now I have 2 problems: first I want to have to have the clients with no intake in the period filtered out of my report (so when the intake = 0 then it doesn't need to show on my list), second I want to have the order/documentnumbers with the intake amounts added to the report (see attached file 1408 how it should be).
Regarding the first problem/question, as you can see, the NL function only filters by country codes. To filter on amounts <>0, I need to make a link to the Sales Line table somehere . In which cell do I need to do that?
Thanks a lot!
Best regards,
Tom
Date
Votes
1 comment
-
Jet Reports Historic Posts You may be able to do this with just two nl( filters) on same sheet
Cell 1 filter table ( Customer master or whatever ) for customer code country etc)
Cell2 filter sales by 1st ( Customer code cell1) 2nd date range etc
use results of cell 2 to deternine which customers to report on
Then you can basically write rest of report based on customers in cell2 and the data in the sales table
Please sign in to leave a comment.