How do I add the territory to the Sage Intelligence Sales Report?
How do I add the territory to the Sage Intelligence Sales Report?
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.
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?
*Community Hub is the new name for Sage City