In other words, each row of my Saved Search would basically represent: • Sales Order • Transaction Line Sequence Number • Item ID • Line Quantity • Lot # • Lot Quantity I’d like to see output that looks like the mock-up screenshot attached here. The problem I’m running into: I cannot figure out how to surface the unassigned entry as its own row, where unassigned (the quantity out of the current transaction line that is not yet assigned to a Lot) is essentially treated as its own unique Lot # within the transaction line. This is especially problematic when a single transaction line has a subset of its quantity set to a Lot # and the remainder unassigned. My best attempt within a Saved Search so far has looked like the following: Type: Sales Order Saved Search Criteria: • Type: is Sales Order • Status: is any of Sales Order:Partially Fulfilled, Sales Order:Pending Billing/Partially Fulfilled, Sales Order:Pending Fulfillment • Main Line: false • Tax Line: false • Item : Type: is any of Inventory Item • Shipping Line: false Results: • Document Number: {tranid} • Item ID: {itemid} • Quantity: {quantity} • Line Sequence Number: {linesequencenumber} • Line Unique Key: {lineuniquekey} • Transaction Serial/Lot Number: {serialnumber} • Transaction Serial/Lot Number Quantity: {serialnumberquantity} I can see several ways to calculate the total unassigned quantity for the transaction line within each row of the saved search (for example, getting the total assigned quantity using something like sum/* comment */({serialnumberquantity}) OVER(PARTITION by {lineuniquekey}) and then creating a separate formula field to subtract that out of the total line quantity, OR using a separate Summary search). But this doesn’t get me to where I want to be: with a separate row for the unassigned quantity of each transaction line. Can anyone see a way to accomplish that in a single saved search? Or would I need to split this work across two saved searches?

Mockup of desired output: