ajackett
2 years agoNew Contributor III
Set column headers for Rolling Forecast scenario based on Actuals or Budget
I am building a Rolling Forecast scenario (eg. name is RFC 2+10) using the below formula snippet which takes the current month actuals, and adds the future Budget scenario. It works well so far, however when I use the scenario in a cube view, I'd like to use the headers based on the source data. So in RFC 2+10, columns 1 and 2 are actuals, and 3 to 12 are Budget. But for each column it just shows RFC 2+10 - is there a way I am able to write something or use some conditional formatting so that show Actuals/Budget based columns?
Thanks