Combine multiple column outcomes in 1 matrix

Anonymous thanks for reaching out. I hope below table with dummy data will help you in testing. I have kept the number of columns limited, in reality the original table has many more columns but for this purpose not relevant.

G/L Account No is used for defining the measures Gross Revenue (1), Direct Expense (2), and Operating Expense (3). The EBITDA measure is a calculation of Gross Revenue (1) - Direct Expense (2)- Operating Expense (3).

For now there are entries with Reporting Type 'Actual' (column value) up until March, and entries with Forecast for the remainder of the year. Next month the table will include also 'Actual' entries for April, thus I must be able to adjust the outcome matrix to show January - April with 'Actual' values, and May - December with 'Forecast' values. The matrix must be able to show different values (Actual and Forecast) of the same column (Reporting Type) depending on Posting Date.

Thanks for your effort!