I have two groups Sales rep and Year(Under sales rep group)
I get the sum of Sales and margin in two columns. I need to know how to insert a difference within each group for Sales and Margin.
Ex: Salesrep1 Sales Total Margin Total
2013 2000 300
2012 1200 200
(I want to have)Difference: 800 100
Salesrep2 Sales Total Margin Total
2013 1000 300
2012 5000 600
Difference: -4000 300
I get the sum of Sales and margin in two columns. I need to know how to insert a difference within each group for Sales and Margin.
Ex: Salesrep1 Sales Total Margin Total
2013 2000 300
2012 1200 200
(I want to have)Difference: 800 100
Salesrep2 Sales Total Margin Total
2013 1000 300
2012 5000 600
Difference: -4000 300