Table Name in the Column of a Matrix

[Anonymous]

I have two tables, "Budget" and "Actuals". They have some simliar columns like "Revenue".

I am trying to create a matrix that shows "Revenue" in a row with "Budget" and "Actual" columns.

e.g.

                  Budget  |  Actual 

Revenue |    $XXX    |   $YYY

I tried to create a new column on both of my tables that indicate whether the value is a "Budget" or "Actual" value, but I can't seem to get that to work. 

Has anyone created something like this before? 

[v-lili6-msft · Accepted solution]

hi, @Anonymous 

In Budget table, add a calculate column 

Type = "Budget"

In Actuals table, add a calculate column 

Type = "Actuals"

Then darg it in matrix

If not case, share some simple sample data and your expected output.

Best Regards,

Lin

[Anonymous]

Thanks Lin!

This worked perfectly.