When we run detailed sales report and group by product, it appears the cost column displays the unit cost per item and the profit column displays the profit per item, but not total costs (cost times quantity) and total profit (profit times quantity).
For example, a row of data reads
qty sold sold price total sales cost profit
2 2.5 5 .59 1.91If I sold 2 items which cost .59 each, that's $1.18 of total cost against $5.00 of sales, leading to $3.82 total profit.
Is there a report that will give me total costs and total profits? It seems like this is the best way to analyze profitability. The unit cost and unit profit and sum of unit costs and sum of unit profits don't tell me much.