I have created a SS to show all Non-Serial Equipment on a Project.
The SS is 'missing' equipment shipped on different days due to the Maximum Summary Type in the Results.
The SS shows duplicate line items when the Summary Type is set to Group.
Setting the Criteria to Main Line = False doesn't correct the issue.
The use case is that we have multiple pieces of non-serialized pieces of equipment shipping on different days. There is no 'unique' identifier that I can figure out how to show this as the equipment is non-serialized, not in a bin or group.
Any suggestions?
For example on the LGR's there was a set of 12 sent out on the 4th, and a set of 10 sent out on the 18th. Minimum/maximum drops one of these shipments.
Keeping Max/Min doesn't show all line items
Thank you for any insight or assistance that you may be able to provide.