Hello!
I noticed with the filter field "Company=" we could select only one company. Is there any other way to take data from a table from several companies?
i.e. List the SUM of Customers' Purchased Amount per Region (with their corresponding Name) in TOTAL for the 3 Companies I have. Saying that customer exists in the 3 companies.
Rrgds,
Cristian
PS: The example above may not exists in NAV as I am using JetReports on a NAV add-on.
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Cristian,
Company= only allows a single company to be specified. You can use NL(Columns) together with NP(Companies) to replicate your companies across columns. Then your NL(Sum) formula can refer to the replicated company and you can sum up the results. I will attach an example using the CRONUS database. Does this work for you?
Regards,
Hughes
Please sign in to leave a comment.