Without VBA you could try this attempt, i might extend it, but not today - it might be a way to solve this without VBA, but I am missing something.



E2=SUMIFS(D:D,C:C,C2)

F2=IFERROR(E2/E1;1)-1


On the PivotTable you add NP and Test2 to the section of values, then you can use Max or Sum for Test2 and it will look like this:



ATTENION here is an error, because summing the differences does not add up, when looking at the YEAR! But however, you can use the given formulas to get to the sums and differnces between the years ;)

Need help using vba to fill in blanks left by excel pivot table when using %difference from previous row
This question brings up an important question:

Do we want to allow or avoid the use of non-standard English such as the words zie and zir as non gender specific pronouns on this site?
