Forum Discussion

timclaeys's avatar
timclaeys
Frequent Visitor
8 years ago

Combine multiple column outcomes in 1 matrix

I would like to compile 1 matrix that can combine different column outcomes for the measures, depending on the months.

 

For example, I want to show for January up to March the Actual outcomes of those measures, and for April up to December the Forecast outcomes. Ideally I want to be able to adjust those periods with a slicer so that next month for example it shows Actual for January - April and Forecast for May - December.

 

Currently I can compile the matrix with only 1 of the column outcomes, so that it shows the measure values for an entire year in the same column outcome (Actual, Budget, Forecast)

 

 

I don't want to create 2 matrices (one for January - March Actual; and one for April - December Forecast) and line them up next to each other.

 

Does somebody know who to handle this? Is there maybe an option in current matrix visual settings that allows it, or does there exist a custom visual matrix that solves it?

 

Thanks.

 

Kind regards.

Need Help

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    timclaeys,

    Could you please share dummy data of your original table so that we can test?

    Regards,
    Lydia

    • timclaeys's avatar
      timclaeys
      Frequent Visitor
      8 years ago

      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!

       

      • lassuied's avatar
        lassuied
        Icon for Advocate I rankAdvocate I
        8 years ago

        Hello !

         

        I know my answer is a bit late but can you create a concatenation of your Year-Month-Reporting type and then trigger the filters ?

         

        Like only filtering those :

         

        201801ACT 

        201802ACT

        201803ACT

        201804BUD

        201805BUD

        201806BUD

        201807BUD

        201808BUD

        201809BUD

        201810BUD

        201811BUD

        201812BUD

         

        But this has to be maintained every month... I do not know if there is a better solution really ...