Skip to Content
Jan 02, 2019 at 08:00 PM

Show Details summed by Shipment instead of Shipment Transaction


The data source for the report contains Shipping transactions. We need to show the sum of shipping transactions per shipment. Here is what I have tried:

1. Using a CrossTab - Sort of works but it is very undesirable for our use case.

2. Using Select Expert - I just don't know how to write a formula to show only unique records. This seems like a hack.

Attached is a preview of the report as it is today. As well as an image marked up highlighting how I am wishing the report could be.

I don't want the transaction level details to be displayed(This data is crossed out). I want to see one entry per shipment with the SUM of all the shipment transaction quantities.

Really appreciate your help!