Hello,
I'm currently working with a Pivot table similar to the attached.
I have added the column 'Sum of Target' by adding a calculated field (as this seemed the easiest way, if there are any other ways of inputting this information this might help), however currently the calculated field is a static value and so if I wanted to change the target value I would need to go into the calculated field settings. Ideally I would like this to reference cell E18 (the cell next to target) so it can be easily altered. However Excel doesn't seem to allow this.
Does anyone have any suggestions?
Any help would be appreciated.
Kind regards,
Oliver
Bookmarks