A. 1. Load the Excel spreadsheet using the data load editor
2 Use the Crosstable function to unpivot the table
3 Create a composite key out of the date and region
4 Connect the new table to the data model

B. 1 Load the Excel spreadsheet using the data load editor
2. Change the sort order by date
3. Create a composite key out of the forecast and region 4 Connect to the existing data model

C. 1. Load the Excel spreadsheet using the data load editor
2. Use the Unpivot function
3 Use the Sum function to group the forecast by date
4 Connect to the existing data model

D. 1 Load the Excel spreadsheet into the data manager
2. Use the Unpivot function
3. Create a composite key from the date and region
4. Connect the new table to the data model
1 Load the Excel spreadsheet using the data manager
2 Rename the ForecastDate field to Date 3. Disable the Region
4 Connect to the existing data model