0

Using filters on multiple tables in nested Sheets-command

Hi All,

I am trying to get a JetReport to generate sheets per Person Responsible showing Project-invoices sent for their projects. Problem is that i can't get their names to show on the tabs, only their ID-numbers.
Here is what I made:
First I filter the Job table for all projects related to a specific department (Global Dimension 1 Code) in cell D3:
||"NL","AllUnique","Job","No.","Global Dimension 1 Code","=""041""","Global Dimension 2 Code","*","","","","","","","","","","","","","","","","" Next I filter table Job Ledger Entry for all Jobs with invoices this period in cell D4
||"NL","AllUnique","Job Ledger Entry","Job No.","+Job No.","@@*","Global Dimension 1 Code","=""041""","Entry Type","Sale","Posting date","01/01/13..31/10/13","no.","<>1230","+Global Dimension 2 Code","*","","","","","","","","" Next I want to make a NL=Sheets statement on the Resource table in cell D5, using the field Person Responsible of the Jobs that are the result of the intersection of D3 and D4. I am trying to do this in a single nested formula as given below.
=NL("Rows";"Resource";"Name";"No.";NL("Sheets";"Job";"Person Responsible";"No.";NP("intersect";$D$3;$D$4)))This however gives me only 1 sheet, just for the first Resource/Person responsible found.
Problem is that I can only choose for Rows or Sheets keyword; my gut feeling tells me it should rather be "Filter", but that results in a #Value error as I cannot use an array in this statement.
Am I doing things very wrong here? How should I go about it to get the results I want?
Thanks for your tips.

Willem

2 comments

Please sign in to leave a comment.