Looking for help from this genius body. I'm trying to create a dimension using a variable that will reference a dimension & month combination but getting nowhere! The table below is an example. My model is quite larger than this, but this simple example is the problem. I want to create a full year scenario called "Cur Fcst" that will pull Actual Jan, Actual Feb, 2+10 Forecast Mar-Dec. How do I do that???
Scenario | Month | Revenue |
Plan | Jan | 100 |
Plan | Feb | 200 |
Plan | Mar | 300 |
Plan | Apr | 400 |
Plan | May | 500 |
Plan | Jun | 600 |
Plan | Jul | 700 |
Plan | Aug | 800 |
Plan | Sep | 900 |
Plan | Oct | 1000 |
Plan | Nov | 1100 |
Plan | Dec | 1200 |
Actual | Jan | 150 |
Actual | Feb | 190 |
2+10 Fcst | Mar | 250 |
2+10 Fcst | Apr | 275 |
2+10 Fcst | May | 345 |
2+10 Fcst | Jun | 415 |
2+10 Fcst | Jul | 485 |
2+10 Fcst | Aug | 555 |
2+10 Fcst | Sep | 625 |
2+10 Fcst | Oct | 695 |
2+10 Fcst | Nov | 765 |
2+10 Fcst | Dec | 835 |