I started recently with ER and besides the MS documentation I can recommend the following youtube video that explains basic things about ER and shows how to change the standard format provided from Microsoft.
You need to go into your model mapping, and either find the SalesTable through relations, or add the table and create your own relations between the tables.
After you have located or added your SalesTable, you can now Map the datasource to the data model. I suggest you add new fields to your data model, in which you can use to map the datasource to. After you have done this complete both the Data model and the Data model mapping.
Now with your new datasources, all you have to do is map them inside the format. But first you need to tell your format which data model to use. You do this by selecting the data model on the Mapping pane inside of your Format. Here you press "Edit" and change the data model version to the one you have just created (Typically the newest one)
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.