You need to add TERRITORY to the SalesMaster 3-0 (AE-SQL) container, then you can add the field to the report.

The field I want is CODETERR and is in ARCUS.  I believe ARCUS is linked the SQL statements, but I cannot find a way to add CODETERR to be a field I can select in modifying the Pivot Table generated

It is not part of the container, you need to add it to the container first.

How do I add it to the container?

Edit the container in the Connector.

I got everything entered, I generate the pivot table and when I added the field and asked for the total to be on top, I do not get summarized data.  I still see customer totals, but I do not see totals by codeterr.  Any ideas?