Excel 2010 - Pivot Table Calc Field

[stapuff]

I am using Excel 2010.


Column Label = "Year_" which has 2012 and 20122
Values = "Sum of Gallons"

I am trying to add a calculated field that subtracts Year_ 2012 Sum of Gallons - Year_ 2011 Sum of Gallons

Any thoughts on proper way to write this

Thanks,

Stapuff

 

[stapuff]

Should be

Column Label = "Year_" which has 2012 and 2011

 

[cyrilbrd]

Hi,

Not sure if this would be what you need.

If:

year	gall
2011	100
2011	200
2012	300
2012	400

then pivot:

Sum of gall		
	2011	2012	Formula1	
Total  	300    	700    	400

Formula 1 being a calculated item such as 2012 minus 2011.

 

[Jerry Sullivan]

If they are in the same field (year), use a Calulated Item