Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Crosstab Profit Margin Calculation

I have a crosstab with SalesRep as rows and Product as Columns. I have SumSales and SumCost in the intersecting cells.

How do I subtract SumCost from SumSales and display this result (SumProfit) in each cell?

Is there a way to calculate the profit margin percentage in each cell .... (SumProfit/SumSales) * 100.

Thank you.

Art

Not what you were looking for? View more on this topic or Ask a question