We are in the midst of changing territories for our Sales folks. I am trying to create an Updatable Dashboard where they enter a state and the dashboard returns the Customer ID, Name, State, and Salesperson.
The problem is that the SalesRepCode field is coming in a numeric value instead of the Name of the Salesperson as it appears in Customer Maintenance in the drop down.
Instead of adding a key at the top of the dashboard explaining which number goes with each person, is there a way I can make the Names appear in place of the numeric values in the dashboard?
The problem is that the SalesRepCode field is coming in a numeric value instead of the Name of the Salesperson as it appears in Customer Maintenance in the drop down.
Instead of adding a key at the top of the dashboard explaining which number goes with each person, is there a way I can make the Names appear in place of the numeric values in the dashboard?