Hello all,

I may be missing something very simple but I am at loss as to how to have a saved search show us Gross Profit Marginh. The catch is, this is a summary by item class. The search shows the total # skus, sales, cogs, and gross profit $ by Item Class but I cannot figure out how to get it to show an accurate GPM since this saved search groups by class and each of the other columns is a sum and you cannot sum the GPM from each sale of the item in the class.

Even looked at reports and it does not seem like you can show sales by item class so abandoned that,

Any help would be appreciated as we need to add GPM to several searches.

Thanks!

Karen
This is a cached copy. Click here to see the original post.