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.