I want to add a column of values to a pivot table as is. It would not be used in any other calculations.
I.E. add something like a satisfaction rating for a company in an area to a table that sums up all the interactions with companies by location and price.
While I suppose it it would be possible to go back into the source data to add this data as a new field, I do not know how to do that.
With regard to how this column would behave when filtered, I would like to be tied to a binary primary key (pretty sure that is not the right way to phrase it, but I mean that it should be tied to the company and location), and insert the correct value when those conditions are matched.
If there is an easier/more sensible way to do what I am asking (and I am sure that is the case) I would happily take that instead.