=E5/D5
, then Excel will create a 'normal' relative formula that can be copied down to all rows adjacent to the pivot table. =GETPIVOTDATA
, you can ensure that you return the proper value from the pivot table. =GETPIVOTDATA
always starts with two particular arguments. It then optionally has additional pairs of arguments.