I have a sales report spreadsheet that shows all actual sales for 10
different sales reps, around 200 rows of separate sales items per rep.
I have created various pivot tables which show month-end, quarter-end
sales, etc. I would like to add a row in the pivot table that shows
each sales reps individual goal for the month and quarter, then show
the actual sales and then the difference between the two. Every sales
rep goal is different and these goals are in a separate spreadsheet.
Is there a way to setup this fixed amount in a pivot table?