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

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

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

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