Building a Vendor Gross Margin Analysis Report

Hello everyone!

I have a project that has been put off for quite awhile which I would like to move forward on. My buyers used a Vendor Gross Margin Analysis report when we were with MBS, and I am trying to make a version of that in NetSuite. I can get pieces of this from the stock ledger, and there are some other reports, or searches where I can get additional pieces of information, but I haven't found a good way to get everything I need for this.

I feel like I am having a metnal Has anyone had success rebuilding this report in NetSuite. If so, could you share some insight with me on how you got everything to come together?