Pivot table column b - column A

[charlesfowler72]

Hi guys,

having some trouble with a calculated column on a pivot table. I thought it should be simple but apparently not. All I need to do is add a 3rd column which will be column B - column A giving me the difference. The pivot table looks as below.

[TABLE="width: 500"]
<tbody>[TR]
[TD]Sectors[/TD]
[TD]201710[/TD]
[TD]201711[/TD]
[/TR]
[TR]
[TD]Sector A[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Sector B[/TD]
[TD]4[/TD]
[TD]1[/TD]
[/TR]
[TR]
[TD]Sector C[/TD]
[TD]3[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Grand Total[/TD]
[TD]10[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]

 

[Roderick_E]

On the Excel menu at top, Analyze/Fields, items, & sets/
Add calculated field, name it something, select your 2 columns and make a formula for subtracting.