I want to perform a calculation on data in a pivot table which I then copy
down row by row but when I copy the formula down it does not work as it picks
up the criteria in the first row of the pivot table.

In old versions of Excel it just copied the simple formula down as opposed
to putting in the pivot table criteria - how do I replicate this?