I have created a Jet report that is pulling Item Sales by Item Category Code. I now need to take that data and have it group the data on a tab for each Ship-To State.
I have successfully created the Link betweed the ILE table and the Sales Shipment Header table, but when the report runs, the data on each tab is the same. It is not just pulling the sales for each state.
HELP :?
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi,
If you're using NL(Sheets) to create your sheets based on the "Ship-to State" field of the Sales Shipment Header table then you should just be able to filter your NL(Rows) function on the Sales Shipment Header by the Ship-to State that is being returned by the NL(Sheets) function. Does that work for you?
Regards,
Hughes
Please sign in to leave a comment.