Pivot table total of running differences

[alanwong1178]

Region	2013		2014		2015		2016
/	Current Year	Diff vs LY		Diff vs LY	Current Year	Diff vs LY	Current Year	Diff vs LY	Total differences
Japan	50		100	50	120	20	90	-30	40
Korea	40		120	80	10	-110	80	30	0
China	70		50	-20	140	90	120	-20	50

I am working on a pivot table with region vs year. For the " Diff vs LY" , I used sum(sales)- before (sum(sales)).

For now, I need to find the sum of all "Diff vs LY" field  as total differences as highlighted in blue as above. 

May I know any method for that? or any method to calculate differences of sales between  latest year (2016)  - first year (2013) in the pivot table?

[Ksrinivasan]

hi,

maxyear-2016,

minyear-2013

so, try this expression

sum({$<Year={'$(=max(Year))'}>} Sales)-sum({$<Year={'$(=Min(Year))'}>} Sales)

ksrini