Hello fellow NetSuiters. I am trying to figure out a saved search that shows total demand per SKU (on preorder quotes), broken out by day. It has been easy to gather aggregate demand but we cannot figure out how to separate it by the dates on the different quotes/sales orders. Thank you!

Do you need each day as a separate column. Or can each day be a new row?

I needed each day to be a separate column, but eventually received a message to use the case when function which seems to be working quite well! The biggest issue with that saved search now is how items always display in base units instead of stocking units (all of our items are set up as assemblies)

I see. I’m not sure how you could have a different UOM other than each for an assembly But all I know is a saved search is able to display the quantity of the transaction or quantity in transaction units