If we do it the “hardcoded” way we get:
This works fine:
But if we switch to 2008:
we loose the forecast.
you can make it dynamic by chancing the “hard-coded” row or column names to dynamic ones using the dollar sign $:
Now you always have a forecast:
Andreas made a smart remark:
Just for completion I would add the fact that $1 stands for the first element of the request. And as a warning (Wow) that the sorting there is determined by the request and not by the constellation in the pivot-table. Because this can cause some people to search around quite long, for example if you change the sorting in the request OBIEE will add up different quarters than before etc.
Till Next Time
PS @eejimkos it works fine in al my browsers: