Hi all,
I have not used the NL("Table") frequently and I have the following questions:
1. Is it possible to run NL("Table") for multiple companies within one statement? The is a "Company="-parameter, but it doesn't seem to accept more than one companyname in its filter.
2. If the above is not possible (I am afraid so), could the following work?:
a. Create a row-replicator on company-name
b. Put the NL("Table") inside the replicator giving the Table a name based on the Companyname. This results in a Named Range.
c. Create a pivottable to further analyze the data from the different Tables/Named Ranges. Th
I managed to complete 2a and 2b but am stuck on 2c. Can anyone point me in the right direction?
Thanks very much in advance!!!
Best regards,
Gerard
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Gerard,
#1 is definitely not possible. As you have seen, #2a and b are certainly possible. I'm really not sure about #2c. In Excel 2013, I was able to create a PivotTable based on multiple tables, but the way it worked was that it required me to create a relationship between the tables that was a foreign key relationship (the sort of relationship that exists between the Customer table and the Cust. Ledger Entry table). It sounds like you are looking to create a union of the data, and I don't think this sort of relationship would be supported by Excel. It seems like you might be stuck using NL(Rows) for this kind of report, but maybe someone else in the community has some ideas.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
Thanks for your response!
2a and 2b are working well. Creating a pivot using Consolidation Ranges doesn't seem an option in this case.
As you mentioned, I will stick to the NL("Rows") for now. Table seemed much easier and also seems to run a bit quicker.
In case someone else has a suggestion…please feel free!
Regards,
Gerard
Please sign in to leave a comment.