Monthly Product Sales Data

This Model Table function is used to hold revenue values generated from the sale of different products.

The function defines the following fields:

• Posting Date: You use this field to provide sales totals on a yearly, quarterly, or monthly basis.

• Channel: You use this field to indicate the channels through which sales were carried out.

• Country/Region: You use this field to store the name of the country/region where the corresponding sales were made.

• Customer ID: You use this field to store the ID of the customer to which the corresponding sales were made.

• GL Account: You use this field to store the name of the products sold.

• Amount [TC]: This is a key figure field that stores the revenue value earned by the sale of each product.

• Currency [TC]: The transaction currency is the currency used in the sample content to calculate profitability. It is common practice to translate every amount into one and the same currency so that only one currency (controlling area currency) is used in the complete profitability model.