Year difference as a new column in Pivot table

[#1]

HI,

i need to create a new colum with differece of two years in the chart

i am sharing the app

provide me the solution

[varunjain · Accepted solution]

THERE YOU GO!!!

[#3]

Hi Varun

its look good  and thanks for your suggestion

[Anonymous]

could somebody help me something different? i.e. chosen a certain month and a certain year, i'd like to visualize values for the selected year, for the previous (-1) one and the differences between the two. in this case it should look as below:

	YEAR	2012	2013	2013-2012
Vendor_Name	Category	DUAL PACK	DUAL PACK	DIFF DUAL PACK
ACTIVE COMPUTER SYSTEMS S.A.	COLOR	336	2136	1800
ACTIVE COMPUTER SYSTEMS S.A.	MONO	1008	13256	12248
HP Shipments	COLOR	628	4960	4332
HP Shipments	MONO	3660	12616	8956