I am looking for an article (that I previously read) which I believe either Tim Dietrich or Prolecto wrote. In this article, they used the

OVER

SQL function to aggregate results. I believe this was on transactions. I am looking to apply this to items and units of measure so I can have Item code, UoM1, UoM2, etc. Right now I have them on separate rows, but I would like to have one row for each Item Code and then all the UoMs in subsequent columns. Does anybody have a link to that article?

Maybe https://timdietrich.me/blog/netsuite-suiteql-item-transactions/ ?

That is the one! You rock!!

All credit goes to Perplexity AI