You cannot add external data to a PivotTable other than by including it in your source data or adding some manual formulas next to your PivotTables (Method 1).

## Method 1

If your satisfaction ratings reside in some other separate table, you can use LOOKUP formulas to tie them to your pivot tables. Say your current PivotTable is Columns A and B below, and want to show company ratings in C:

```
A B C
Location1 Some data rating
-- Company1 1000$ ****
-- Company2 500$ ***
Location2
-- Company1 1000$ ****
-- Company2 2500$ ***
```

If you have your rating data in another table somewhere else (say sheet2)

```
A B
Company1 ****
Company2 ***
```

You can use the VLOOKUP formula in column C to fetch it:

```
Location1 Some data rating
-- Company1 1000$ =VLOOKUP(A1, Sheet2!A:B, 2, FALSE)
```

The downside is that any change in your PivotTable will likely break things and you'll need to readjust your formulas.

## Method 2

To make your PivotTable handle the ratings automatically, you should really add a new column to your source data called "rating" which can be a column contains a VLOOKUP formula that fetches ratings automatically from another table (so you maintain your ratings in just one place that will be reflected when refreshing your PivotTable.

That's assuming your PivotTable gets data from Excel. If your data does come from SQL or Access, you would need to either have access to that source, or download that data as a regular table (instead of straight-to-pivot), add that formula column, and make a local PivotTable out of *that* intermediary table. Either way, your final pivot table would have a usable "Rating" field you can put in Row Labels.