Pivot table total of running differences

alanwong1178 — Sat, 16 Nov 2024 00:31:38 GMT

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?

Re: Pivot table total of running differences

Ksrinivasan — Fri, 26 Feb 2021 03:44:33 GMT

hi,

maxyear-2016,

minyear-2013

so, try this expression

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

ksrini