Hi all, hoping some one can help me please with some MDX.

I have the following simplified structure in a cube, we do forecast revisions during each quarter during the year however we only store the revision data for the remaining periods in the year not the preceding ones as by this point we already have the actuals.

So what I want is for when a user selects a Version e.g. '2017 Q3 Forecast' we should return the Q3 and Q4 forecast figures along with the Actuals for Q1 and Q2, I don't want to replicate the data as its quite large volumes.

Could someone please provide me with a sample MDX query or point me in the right direction which might achieve this.

Many thanks in advance!

Forecast.png